I've got many formulas listed like below, but want it so that a cell containing a date in another worksheet which matches with a header in a column, copies and pastes that column as values, but leaves the other un-matching date/headers as formulas instead of values.
EX- The date on the "Import" tab in cell E11 is 02/2016
The data in the "Total" tab looks like this:
01/2016 02/2016 03/2016
208 =Formula1 =Formula1
304 =Formula2 =Formula2
523 =Formula3 =Formula3
232 =Formula4 =Formula4
(This is because I'm adding data to a tab which populates the formula of the total tab)- This will change with the date because of formulas so I need to copy and paste as values.)
So what code can I use to make it so that I can enter a new date into the cell and have a VBA which copies and pastes the cells under that date in a different worksheet (same workbook)
EX- The date on the "Import" tab in cell E11 is 02/2016
The data in the "Total" tab looks like this:
01/2016 02/2016 03/2016
208 =Formula1 =Formula1
304 =Formula2 =Formula2
523 =Formula3 =Formula3
232 =Formula4 =Formula4
(This is because I'm adding data to a tab which populates the formula of the total tab)- This will change with the date because of formulas so I need to copy and paste as values.)
So what code can I use to make it so that I can enter a new date into the cell and have a VBA which copies and pastes the cells under that date in a different worksheet (same workbook)
