Okay, thanks
I've just made a little file to hopefully show what is needed.
things that the code needs to do:
1. Identify when Column B changes value, then insert two blank rows above and below
2. Identify matching values in Column B and C (Task_ID and Parent_task) because the same Task_ID and Parent_task is located in different places in the sheets.
3. insert "Begin" above the cell in the new blank row in Column C where the values changes
4. Insert "end" below the cell in column C where the value changes
5. Copy values from column D-F from matching row in column B
6. Paste matching values from Column D's into the same row as the new "begin" and "end" Rows.
Don't know if make sense?
So main thing is the identify matching values from Parent_task and Task_ID and the insert two blank rows above and below where the values in Parent_task Column (Column C) changes, and copy the cells from matching column C (but only the columns D-F's cells in the same row as the matching value in column B is.
Bookmarks