Hi All,
I'm new to this forum.
I have a table in excel sheet with several columns; the leftmost column has the names for each row and a subtotal.
The top 3 rows are headers with different names.
I have a task to match the top row with a cell in another sheet and then the Month name in second row.
Based on which I need to obtain the value from the 12th row in the same column.
This has to continue for all the columns.
I have written a Macro, but I'm facing initial hurdle of getting the address of the "arng".
Please help:
Bookmarks