I have set up a drop down (data validation) list. The drop down list allows the user to select one of 23 unique options and then see a specific projection for each of them. There are a lot of if statements set up to pull data from other worksheets to populate the information. The issue I am running into now is that we also want to create a summary projection for a subset of 11 groups, a subset of the other 12 groups and all 23 groups. Thank you for any guidance you can provide!
Hello heron8235 and Welcome to Excel Forum.
I feel as if we would need to see a small desensitized sample of what you have and what you want to have (manually mocked up).
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks