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.
