macro put formula inside cell based on date of another cell

[tonyjyoo]

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?

 

[Norie]

How is the cell to put the formula in determined?

Is it based on something in the raw data file?

 

[tonyjyoo]

Yes, there will be 4 separate companies with varying deposits/withdrawal amounts, and I would utilize a sumif formula to capture the sum of all the deposits/withdrawals for each company separately.

I know how to write VBA to input the formula in the cell, but don't know how to add to it so that it knows which cell to enter BASED off the dates above them. For example, if today's date (12/20/16) was in B1, tomorrows (12/21/16) would be B2, and so forth.