Hi everyone,
I'm really hoping someone can help me out with this, I've been scratching my head with this one all morning.
Basically, my boss wants one excel sheet to display all information needed for several businesses we support.
My plan was to do as follows:
Create a main header with a list of all the information required for the businesses at the bottom. The business partner would select his/her business from a drop down on the right, and all the data pertaining to the business selected from the dropdown would be sorted/displayed at the bottom.
I currently have it where all the data is viewable and the business has to sort the column which applies to them, but I would rather clean this up and make it as user-friendly as possible.
I've attached a very basic example of what I'm trying to do, just in case the way I worded it isn't as understandable as I think (I'm somewhat of a beginner with Excel).
One option which would be even better was if I could keep the data on hidden sheets within the document (so they are easily modifiable by my group) but that when the business partner selects their business, the data is pulled from the hidden sheet and displayed at the bottom.
Any advice or tips would be greatly appreciated!!
Thanks!
Bookmarks