O
Osvaldo
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.
(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.