I've got a mini project whereby I need four worksheets:
Master
Channel 1
Channel 2
Channel 3
Example data be seen on the attached screenshot.
For the master sheet, there are three sales channels, with each of which having two plans. Each plan may or may not have an associated item, and if it does, the cost could be free.
On the channel sheets, I am hoping to list only items that have an associated plan. Per the screenshot, Channel 1 does not list Item 2, and Channel 3 only lists Item 2. Please note that there will likely be hundreds of items in the final spreadsheet.
Is this achievable in Excel?
What formulas would I use so that only valid items are present on the 'Channel' worksheets?
If I were to add items to the Master worksheet, could the other sheets automatically update?
There will be a need to add 'Plans' in the future - will the 'Channel' worksheets cope with this?
Any help would be most appreciated - do let me know if this is better suited to a database, though I was hoping to not having to go down that route!
Bookmarks