Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
I have a drop down list A-Z, and I have Sheets A-Z, each sheet has data specific to that letter.
I want to be able to select a letter in the drop down and then below the drop down it pulls all the data from that specific sheet name into the current working sheet. How would I go about doing this? I've looked at vlookup and indirect but can't seem to get it to work correctly.
I want to be able to select a letter in the drop down and then below the drop down it pulls all the data from that specific sheet name into the current working sheet. How would I go about doing this? I've looked at vlookup and indirect but can't seem to get it to work correctly.