I have a calculation sheet with live formulas that contains data with column headings titled 2020-2028 (9 columns) (B2:B10)
On an input sheet, I have START and END dates in two different cells (A1,A2)
With that said, I would like a VBA macro that is able to look at the START and END dates on the input sheet, and based on their presence in the range defined by (A1,A2), delete the columns that are out of range on the calculation sheet.
Theoretically, only year columns within the START and END Year range will be left on my calculation sheet.
Any feedback or further direction is greatly appreciated.
On an input sheet, I have START and END dates in two different cells (A1,A2)
With that said, I would like a VBA macro that is able to look at the START and END dates on the input sheet, and based on their presence in the range defined by (A1,A2), delete the columns that are out of range on the calculation sheet.
Theoretically, only year columns within the START and END Year range will be left on my calculation sheet.
Any feedback or further direction is greatly appreciated.