I've got a row (Q1:BH1)with mutually exclusive dates. My 2nd row has formulas (Q2:BH2) that pull in related data.
I've also got 1 cell with a specific date (Q13)
If a date on my first row matches to the date in cell Q13, I want to copy/paste special values in the 2nd row in the cell below the matching date in order to get rid of the formula.
I've also got 1 cell with a specific date (Q13)
If a date on my first row matches to the date in cell Q13, I want to copy/paste special values in the 2nd row in the cell below the matching date in order to get rid of the formula.