Combining data in multiple worksheets into

[TDoran]

Hello,

I converted a 128-page PDF file with data laid out in columns and rows into a spreadsheet. However, the spreadsheet/workbook has 108 individual worksheets, and the data does not extend beyond row 50 in any of the individual worksheets. (I converted it using a pdf to Excel Web site.)

I would like to combine all the worksheets into one. But I cannot figure out how. I have looked both in Microsoft help and searched this site, but have not found anything on point. My apologies in advance if I missed it.

BTW, I must also congratulate you for creating one of the most useful sites/blogs I've encountered. And thank you for sharing your knowledge.

Tim

 

[Hui]

I would write a quick macro to


Go from sheet 2 to the last sheet

Copy the first 50 Rows

Go back to Sheet 1

Paste the copied data at the bottom of the current data

repeat until you get to the end

 

[oldchippy]

Hi TDoran,


You may find this link useful


http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Intne.html

 

[TDoran]

I thank both of you for the suggestions. I will give them a try.

Tim