Trying to aggregate multiple worksheets to have a "working log" of all departments.

[ILO92]

I'm trying to figure out a way to write a macro in VB to clear and overlay the information in the Summary tab with the combined details of all of the other tabs. I would need to retain the header (Rows 1-3) on the Summary tab and only carry over the details from the other tabs. I've attached a basic workbook to illustrate the setup, the "Desired Outcome" tab is what I'm trying to achieve. It should also ideally sort using the "Responsible" column first then "Complete Y/N".

Thanks in advance for any help you can provide!

[MarvinP]

Hi and welcome to the forum,

Try this VBA code to do what you want. Make sure your "Summary" sheet is the first one on the left before running the macro.

Please Login or Register  to view this content.

[ILO92]

Hey thanks for your quick response. I tried the code you have me, and I immediately get a Run-time error '1004' (Application-defined or object-defined error). Any other ideas?