Good Morning,
I have a file with 50+ worksheets, and I am trying to select all sheets, and copy them into one single worksheet. Is that possible? Thanks much.
Good Morning,
I have a file with 50+ worksheets, and I am trying to select all sheets, and copy them into one single worksheet. Is that possible? Thanks much.
I'm assuming each sheet has identical layout, perhaps varying in # of rows.
1) What columns are being copied?
2) What row does data start in? (I assume you don't want to re-copy headers, if any.)
3) Is there any column that ALWAYS has data from top to bottom, with no blanks? (We can use that to find last row.)
Thank you for your response. I had to go in another direction, but appreciate your help!
Perhaps you could share your solution so others could learn from it.
In any event, you "OWN" this thread, so if you're done with it, please go to Thread Tools up top and mark it as SOLVED. Thanks-Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks