Hello
I have similar data multiple worksheets. I want to be able to switch the worksheet my main tab is referencing using a dropdown list.
Let's say for example I have multiple worksheets containing similar data from different months. 'Nov21' 'Dec21' 'Jan22' etc.
Going forward I will create a new tab with data at the end of each month.
On a main sheet I want to use a vlookup function to reference the other tabs. What I'd like to do is use a drop down list and select between the different worksheets where the data in my main tab will pull data from the relevant worksheet. Can this be done?
Thank you
I have similar data multiple worksheets. I want to be able to switch the worksheet my main tab is referencing using a dropdown list.
Let's say for example I have multiple worksheets containing similar data from different months. 'Nov21' 'Dec21' 'Jan22' etc.
Going forward I will create a new tab with data at the end of each month.
On a main sheet I want to use a vlookup function to reference the other tabs. What I'd like to do is use a drop down list and select between the different worksheets where the data in my main tab will pull data from the relevant worksheet. Can this be done?
Thank you
Last edited: