Good afternoon everyone,

I am having trouble finding a solution to the current problem I am having. I have an Excel workbook "Weekly Metrics Admin Tool" that has two buttons. The first button opens a database that houses a bunch of queries that generate the weekly metrics reports. However, when I click it, it targets ALL the data in the tables and not just last week, what I am reporting on. I know I can go in and use a LIKE "Week 49", but I do not want to have to change it every week.

My initial thought is to have a cell in the workbook with the admin buttons where I can quickly enter the week I want it too target but I need help with the VBA to have it reference that cell and modify the query!

Any help would be greatly appreciated!