• 0

excel file merge issue


Question

there is a file with 150 pages of data in excel. the data is of the same type i.e same columns in all 150 pages,

id like to merge all 150 pages into 1 single page. how can i do that?

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

By pages, do you mean tabs?

You could record you doing it on the first 2, then use VBA and loop it up for the remaining tabs.

Link to comment
Share on other sites

  • 0

Open up VBA & write some code to iterate through all your worksheets and add the contents onto the bottom of the first sheet.

Keep in mind that Excel 2003 files are limited to a max of 65536 rows; Excel 2007 onwards will depend on the amount of RAM you have available.

Link to comment
Share on other sites

  • 0

Open up VBA & write some code to iterate through all your worksheets and add the contents onto the bottom of the first sheet.

Keep in mind that Excel 2003 files are limited to a max of 65536 rows; Excel 2007 onwards will depend on the amount of RAM you have available.

wish i knew how to write code

Link to comment
Share on other sites

  • 0

By pages, do you mean tabs?

You could record you doing it on the first 2, then use VBA and loop it up for the remaining tabs.

tabs/sheets/pages.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.