Hi guys,
I have multiple sheets which are the same structure however with different cell data.
I would like to be able to pick a dropdown which is populated by the first part of a sheet references.
when a dropdown is picked then two ranges should be shown in two boxes on a mastersheet.
I have attached a sheet for reference.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Output" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in H3. If you add or delete sheets, the drop down in H3 will update automatically. Make sure that all the sheet names have " - " as a separator.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank it works splendid
I can see that it work if all sheets have a "-" is it possible to get it to work without all sheet includes a "-" separator e.g. Master, sheet1, sheet2 - something, sheet3 ?
Btw. thanks a lot
Try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks