MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Consolidation


Posted by AL on January 05, 2002 2:31 PM

I have information in the following cells.
CA7:CA23
CN7:CN23
DA7:DA23
DN7:DN23
EA7:EA23
EN7:EN23
FA7:FA23
FN7:FN23
GA7:GA23
GN7:GN23
HA7:HA23
HN7:HN23
IA7:IA23

What I need to know is how to consolidate the above information
Into another sheet called January Consolidation,
from a sheet called data entry

B5:B21 for CA7:CA23
C5:C21 for CN7:CN23
D5:D21 for DA7:DA23
E5:E21 for DN7:DN23
F5:F21 for EA7:EA21
G5:G21 for EN7:EN23
and so on FA7:FA23
for the rest FN7:FN23
GA7:GA23
GN7:GN23
HA7:HA23
HN7:HN23
IA7:IA23

Thanks for any help

AL


Posted by Scott on January 05, 2002 4:39 PM

You can create a link to the cell on the consolodation sheet. Lets say that your information is on Sheet1. In cell B5, type in "=Sheet1!CA7" (without the ""). Then you can copy this over and down to B21. You can do this for each set of info. Another way would be to copy the info, and then use Paste-Special-PasteLinks.