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