combining multi sheets into 1

[MrSales]

I have just converted a pdf file to excel that has seven pages. It transferred but each page is on its own sheet. How can I combine them on one sheet simular to word? I want it to be on one sheet only.

Thank you,

[JONvdHeyden]

Hi

It's a little tricky to suggest code without knowing the construct of you data in the sheets.

The following will copy data from all but the 1st sheet and paste it beneath the existing data in the 1st sheet. Assumes data starts from A1 and that the last occupied cell in column A is suitable to identify where the next set of data should be appended to.

Please Login or Register  to view this content.