![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Box | Excel | 1 | 05-03-2014 11:55 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
![]() |
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Populate cells in Word from a database | hotlilshan | Word | 3 | 12-09-2008 01:51 PM |