Macro to grab multiple rows and sum on different sheet

Hey Guys,

I am trying to grab data from sheet 1 and bring to sheet 2 based on certain criteria. I have attached an example to help with my explanation (most likely terrible/confusing)!

On Sheet 1 there is a list of buildings down column A and years across the top row. I would like the macro to do the following:
1. If there is activity for the building, regardless of the year, then grab the building name and take to sheet 2
2. For all the buildings with activity, take the total of the activity and deposit the total in the column of they last year of activity on sheet 2 (in the corresponding year).
3. Insert 4 rows between the returned buildings
4. Add the following to inserted rows Outside, Inside, Improvements to rows 1, 2, 3, respectively


I also added a 'final' tab on my sample to help show what I want the final product to look like after the macro has run.

I appreciate the help and thanks in advance!

Attachment 273266

Try this:

Please Login or Register  to view this content.

Still looking for some help on this problem. Thanks.