Results 1 to 2 of 2

Thread: Excel formula to copy from random colums

  1. #1

    Excel formula to copy from random colums

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I need some help with a formula ,

    I have a excel with a lot of column and i need to divid it, in different spreedshet , imagina i have this column A B C D F G AA AB AC AD AF AG BA BB BC BD BF BG and i want to have 6 diferent spreedshet qhere i have column A AA BA ; B AB BB; C AC BC ; ....... ; G AG BG .

    How can i do a formula to bring specific column?

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Excel Version
    Office 365
    The problem with that is that once you split it you still want to edit it either in the original sheet or in the shortened sheets.
    You could for instance create a new sheet (call it A) and in a1 have the formula =AA1 and copy that down
    The problem is if you edit the original sheet then go to sheet A and edit there you loose the formula and replace A!A1 with the new value not Orig!AA1

    I suggest that multiple views is actually what you are looking for. Read this

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts