Hi All,
Another beginner question, I have a list of tasks (column A) and resources (row 1) with hours for each in a grid pattern. I need to run a macro that looks through the grid and finds the hours greater than 0 and then returns the task name and resource name into a new table (from row 7 downwards with tasks in column 1 and resources in column 2). I am using "END" as a stopping point after the very last entry in the grid (cell D5). I've played around with a few different attempts at this, but always getting an error, can someone please help with the code below and see where it is going wrong? I would greatly appreciate any help!
Bookmarks