merging sheets
Hi, I have several xls files (worksheets files, right?), each with several
(between 10 and 80) sheets (sheet1, sheet2, ..., sheetn). Within each sheet the information is in the first eight columns (from A to H) and from row 1 to row 60, but the last sheet may have less than 60 rows. I need a macro which copies to that sheet1all the content from sheet2 to the very last sheet. Afterwards, I need to copy from all other sheets from the other worksheets to the very first sheet1, always under what has already been copied, so that all data are in only one sheet. How one can accomplish that? By doing this manually (copy and paste) is time consuming, non productive and prone to errors to say the least. Thank you so much for any help. |
All times are GMT +1. The time now is 11:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com