It would be based on the date of the daily balance summary. For instance if the daily balance summary file has "4/15/15" then that net sales figure needs to be entered into the sales sheet under the column labeled "4/15/15," under the appropriate store number.

The before and after parameters are based on the dates of the ad. So the macro would need to match up the date on the daily balance sheet and the store number and then find the cell in the sales sheet that matches up to both those parameters.

Does that make sense?