Tilt090 Posted June 18, 2012 Share Posted June 18, 2012 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 More sharing options...
0 +Dick Montage Subscriber² Posted June 18, 2012 Subscriber² Share Posted June 18, 2012 CTRL + C CTRL + V Link to comment Share on other sites More sharing options...
0 Tilt090 Posted June 18, 2012 Author Share Posted June 18, 2012 CTRL + C CTRL + V i was looking at not doing the ctrl+A ctrl +c ctrl +v 500 times... Link to comment Share on other sites More sharing options...
0 Tilt090 Posted June 18, 2012 Author Share Posted June 18, 2012 any efficient less mind deadening way of doing this?? :cry: Link to comment Share on other sites More sharing options...
0 spikey_richie Posted June 18, 2012 Share Posted June 18, 2012 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 More sharing options...
0 Kami- Posted June 18, 2012 Share Posted June 18, 2012 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 More sharing options...
0 S_Herbie Posted June 18, 2012 Share Posted June 18, 2012 Download the ASAP Utilities add-in - this has a very quick tool to merge data from more than one sheet / file... http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=36&utilities=20〈=en_us Link to comment Share on other sites More sharing options...
0 Tilt090 Posted June 18, 2012 Author Share Posted June 18, 2012 Download the ASAP Utilities add-in - this has a very quick tool to merge data from more than one sheet / file... http://www.asap-util...s=20〈=en_us great ill look into this! S_Herbie 1 Share Link to comment Share on other sites More sharing options...
0 Tilt090 Posted June 18, 2012 Author Share Posted June 18, 2012 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 More sharing options...
0 Tilt090 Posted June 18, 2012 Author Share Posted June 18, 2012 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 More sharing options...
0 S_Herbie Posted June 18, 2012 Share Posted June 18, 2012 By pages, do you mean tabs? ... By tabs, do you mean Worksheets? :D Link to comment Share on other sites More sharing options...
Question
Tilt090
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