Excel formula to copy from random colums

Tomas

New member
Joined
Apr 8, 2014
Messages
1
Reaction score
0
Points
0
Hey,

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?
 

WizzardOfOz

New member
Joined
Sep 4, 2013
Messages
184
Reaction score
0
Points
0
Location
Australia
Excel Version(s)
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 http://www.officetooltips.com/excel/tips/viewing_a_worksheet_in_multiple_windows.html
 
Top