I'm new to writing macros. I came up with an idea for an export and was hoping someone could assist in how to automate. I've provided an attachment of a very generic mock export with a second tab containing what I want it to look like after I run the macro.

Background:
I produce exports from MS Project which provides a list of my tasks and summary tasks presented as it appears on the tab 'Export'.

However, for the purposes of this export I am to perform frequently- I want to take the Summary Tasks out of the 'Task Name' column and populate in a new column. I need the program to recognize where to put the data based on information contained in Column F (View Filter).

Steps:
First step is: Insert a column between B and C and title it "Sub-Phase". (I can write this part)
Second step: Find any row containing "Phase" in Column G (View filter) and delete. (I can also write this)
Third step: Find "Sub-Phase" in Column G and copy the contents of D#(whatever row # Sub-Phase is contained in) and paste down in column C until the cell just before the next Sub-Phase.
Step 4: Find all rows containing "Sub-Phase" and delete. (I can also write this)

The finished product should look like the tab I titled "End Result"

Your help is much appreciated!
Thanks
E

Attached Files

sample.xlsx (9.7 KB, 13 views)