Hello Forum,
I would like to think there is a way to do this (non-VBA) but I do not know how and am hoping that someone can help.
Worksheet1 is a collection of rows from another source. I need to consolidate the rows into another spreadsheet without the blank rows from Worksheet1. A mocked up example using some rows is shown in Worksheet2. I need to copy over all the rows from Worksheet1 into Worksheet2, if, Worksheet1 has a name in column A, and, hours in any columns of G, K, O.
Then in Worksheet2, I need to SUM all the planned hours, by column (I, M, Q), by resource. I provided an example of what this would look like at bottom of Worksheet2. I do not know how to get all of the resources at the top of Worksheet2 listed into one column without duplicating any of the resources.
Please help if you can. Thank you very much in advance.
Bookmarks