copy many sheets into one

A

Annie_Ioceva

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data from 1 Sheet to Another 3
SUMIFs across multiple sheets 7
Return Unique Entries Only 5
Excel EXCEL HELP! Need to copy cell into the same worksheet name 7
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Copy non merged to merged cells again 1
Group information from several worksheets into one worksheet 1
Problem in If function 7

Top