Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging sheets | Excel Discussion (Misc queries) | |||
merging sheets | Excel Worksheet Functions | |||
merging data from two different sheets | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Merging two spread sheets | Excel Worksheet Functions |