Creating a chart referencing data in multiple sheets using a drop-down list of sheet names
I need help in creating a date vs score chart in excel. The issue is that the chart should have a drop-down list containing the name of the sheets which have the data in it in such a way that when a sheet is selected from the list the chart displays the data regarding that particular sheet. I don't mind using macros to accomplish the task, so please guide me on how I can do it. Unfortunately I cannot attach the file since its 6MB size.
Duplicate thread closed. Continue here, pleaae: https://www.excelforum.com/excel-pro...eet-names.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks