Hey Guys,

Im fairly new to VBA but not a newbie. I was wondering if you guys could help me. I am trying to create a sales projection calendar. Every month I pull a report from Access and export it to excel and create a table from the report. The table shows the store ID number in column A, Date of Sale in Column B and Sales amount in Column C.

I need some advice/help on how to create a macro that will allow me to automatically match the day of each sale to the day of the upcoming calendar( example match the first tuesday of november with the first tuesday of december kind of thing and match the sales with that date. I have the table in one work sheet and the sales calendar/projection in a separate worksheet

Also whats important to know is that we have multiple store IDs and sales dates and numbers will vary in the sense that there is not a fixed number of rows to get the data for Each store ID from. Is there a way to create codes that will allow it to determine which store ID it is for?

Cheers everyone