Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to compile data from col A in many identical sheets
Hi, using xl2003. Looking for help with a sub to do this.
I'm in Sheet1. To the right of this tab, there are 60+ sheets, identically structured, named as eg: Zone1, Zone2, etc In each zonal sheet, in A4 down contains data that I would like to compile into a new sheet like this: In the new sheet, In cols A and B, in row1 down (xx1, xx2, etc indicatively are data in A4 down, Zone1, Zone2, etc indicatively are the respective sheetnames) col A = o/p the data from A4 down col B = o/p the sheetname xx1 Zone1 xx2 Zone1 ..... xx1 Zone2 xx2 Zone2 ..... xx1 Zone3 xx2 Zone3 etc Then to snake over and continue the results output into adjacent cols C and D once cols A and B are full, eg: In cols C and D, in row1 down xx1 Zone40 (example) xx2 Zone40 ..... xx1 Zone41 xx2 Zone41 ..... xx1 Zone43 xx2 Zone43 And so on, outputting to yet other adjacent cols in this new sheet until its all done. I estimate there's around 200K+ data rows altogether in the 60+ sheets. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to compile data from col A in many identical sheets
Missed out this line in the earlier description:
I would like to fire the sub in Sheet1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to compile data from col A in many identical sheets
Any help, pl?
I'm basically looking to append all the col A data into one long col, with the corresponding sheetname placed in the col next to it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging two sheets with non-identical data | Excel Discussion (Misc queries) | |||
Compile data on multiple sheets. | Excel Programming | |||
Compile 6 identical ranges(size and fields) into a text file. | Excel Programming | |||
comparing identical rows in different sheets | Excel Programming | |||
comparing identical rows in different sheets | Excel Programming |