Hello,
I have a VBA macro which opens up a file with raw data. I want the next step to go back to my main workbook and enter a SUMIF formula in the corresponding cell based on the date in the cell above it.. for example column B would be 12/1/16, column C is 12/2/16, etc.
Is there a way to do this?
I have a VBA macro which opens up a file with raw data. I want the next step to go back to my main workbook and enter a SUMIF formula in the corresponding cell based on the date in the cell above it.. for example column B would be 12/1/16, column C is 12/2/16, etc.
Is there a way to do this?