copy many sheets into one
 

Hello,
I spent a day trying to merge columns from different sheets into one sheet.
My case is: I have 52 sheets named: 1,2,3,4,5 ...52 with the same format. I
need to copy column A content ( A3:A66 ) from all these sheets into one
column in a sheet "Source" as the content is appended sequentially below:
A
-----------
'1'!A3
'1'!A4
'1'!A5
....
'1'!A66
'2'!A3
'2'!A4
....
'2'!A66
....
Any help would be highly appreciated ;)
Thank you,
Annie

copy many sheets into one
 

Hi Annie

See this page for a few examples
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Annie_Ioceva" wrote in message ...
Hello,
I spent a day trying to merge columns from different sheets into one sheet.
My case is: I have 52 sheets named: 1,2,3,4,5 ...52 with the same format. I
need to copy column A content ( A3:A66 ) from all these sheets into one
column in a sheet "Source" as the content is appended sequentially below:
A
-----------
'1'!A3
'1'!A4
'1'!A5
...
'1'!A66
'2'!A3
'2'!A4
...
'2'!A66
...
Any help would be highly appreciated ;)
Thank you,
Annie