This is probably very simple, but I can't think of the right solution at present.
Spreadsheet
On a seperate Sheet, i need to add a formula that will look across row 1 for xDate, then row 2 to find Header Title then find row related to Totals in Column A and result with the answer to that column/Row intersection.
Example- Find Total Number for Feb 19 = 7 (G6)
To Note, total row will move up/down depending on imported data,
Date and headers can be based on a lookup option, i.e the headers/dates will be included as headers in the new results sheet. But not included in the same repeat layout!
Any tips?
Spreadsheet
On a seperate Sheet, i need to add a formula that will look across row 1 for xDate, then row 2 to find Header Title then find row related to Totals in Column A and result with the answer to that column/Row intersection.
Example- Find Total Number for Feb 19 = 7 (G6)
To Note, total row will move up/down depending on imported data,
Date and headers can be based on a lookup option, i.e the headers/dates will be included as headers in the new results sheet. But not included in the same repeat layout!
Any tips?