MrExcel Publishing
Your One Stop for Excel Tips & Solutions

merging wooksheets

Posted by R.Brayton on July 06, 2001 12:51 PM

Hi, back again. Can anyone yell me if there is a way to merge the data on multple worksheets onto one sheet in a workbook without using the obvious copy and paste method? Thanks again, this site is great!

Posted by David on July 06, 2001 1:27 PM

you are going to have to be more specific. there is no easy way but with a little code you can make it easy.

you want one sheet on top of the other

is this a once and done thing or are you going to be doing it often

Posted by R.Brayton on July 07, 2001 7:00 PM

I have 15,000 rows on page 1, 11,000 rows on page 2, 6,000 on page 3 and 62,000 on page 4. My goal is to condense all these records down to 2 pages. It is a one time proceedure, but as more records accumulate I would need to do the same again. Thanks again

Posted by David Rainey on July 09, 2001 12:09 PM

I know its not what you want to hear but copy and paste seem like the best bet.