Macro to return task/resource names from grid

[aBc894543]

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!

Please Login or Register  to view this content.

[aBc894543]

Attaching an example file for reference, any help here would be greatly appreciated!

Thank you in advance.

[Kaper]

Try this way:

Please Login or Register  to view this content.

[aBc894543]

Excellent! Works perfectly, thank you so much Kaper!