Populate Column 1 with data from cells in Column 2 based on data contained in Column 3
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
Last edited by EC37; 07-15-2014 at 08:41 AM.
Reason: identifying steps I can write myself
|