Dear Excel-specialists,
I have a short question.
I have 1 master workbook that contains several worksheets, including a Summary worksheet.
The header for each worksheet is the same (from row 1:11). This also counts for the Summary sheet.
What I like to achieve is:
- walk through all worksheets in the workbook (could have different names) except the worksheet with the name "Summary"
- Copy all data that lives (per column A:Z) in all worksheets starting from row 12 until there is no data found
- Make a summary of all collected data, leaving empty cells out and put this in the summary worksheet also starting from row 12
Result: A summary of all the data from the worksheets starting from row 12.
My problem: The script gives not the desired result in the summary worksheet.
Column D stays empty (priority 3) and the word "Integration complexity" Cell H9 is also copied.
Can somebody help me out please?
Code an sheet is included.
Thank you in advance!
Best regards,
Hans
Bookmarks