I have been tasked with something I am not even sure can be done. We have a template that we use for our budget input. This workbook uses drop down lists for the columns (most), one of which is a dependent drop down list. This dependent drop down box is used when identifying a channel, the Channel Support column is dependent on the Channel Category column.
We are trying to reduce the number of lines in our main document so we would like to create a Channel Category that would represent multiple Channel Support line items. In the past this is what it would look like:
(This is just a sample and does not represent and actual line, there are many more columns)
Campaign Channel Category Channel Support
Blue Sky Paid Media Out of Home
Blue Sky Paid Media Broadcast
Blue Sky Paid Media Radio
Blue Sky InStore POP
In the future, this is what we want it to look like:
Main Worksheet
Campaign Channel Category Channel Support
Blue Sky "Sweet" Multiple
Brown Grass "Tart" Multiple
Detail Worksheet (created by selection of Sweet or Tart
Campaign Channel Category Channel Support
Blue Sky Paid Media Out of Home
Blue Sky Paid Media Broadcast
Blue Sky Paid Media Radio
Blue Sky InStore POP
Brown Grass Paid Media Digital
Brown Grass Paid Media Social
Brown Grass Owned media Content Update
On the main document there will be two lines with the Channel Category of "Sweet" and "Tart" and the Channel Support of "Multiple". But here is where it gets tricky. When the "Sweet" or "Tart" Channel Category are selected, it would populate the detail worksheet with the detail of what it represents. "Sweet" and "Tart would represent static lists of Channel Categories and Channel Support.
The line items being created on the Detail worksheet would be exactly like the one on the main worksheet, with just the Channel Category and Channel Support columns updated with the actual Channel Category and Channel Support that "Sweet" or "Tart" represents. (shown in Detail worksheet above)
Is this something that can be done? Or is there another way to make it work?
Thanks for your help,
Ellen
We are trying to reduce the number of lines in our main document so we would like to create a Channel Category that would represent multiple Channel Support line items. In the past this is what it would look like:
(This is just a sample and does not represent and actual line, there are many more columns)
Campaign Channel Category Channel Support
Blue Sky Paid Media Out of Home
Blue Sky Paid Media Broadcast
Blue Sky Paid Media Radio
Blue Sky InStore POP
In the future, this is what we want it to look like:
Main Worksheet
Campaign Channel Category Channel Support
Blue Sky "Sweet" Multiple
Brown Grass "Tart" Multiple
Detail Worksheet (created by selection of Sweet or Tart
Campaign Channel Category Channel Support
Blue Sky Paid Media Out of Home
Blue Sky Paid Media Broadcast
Blue Sky Paid Media Radio
Blue Sky InStore POP
Brown Grass Paid Media Digital
Brown Grass Paid Media Social
Brown Grass Owned media Content Update
On the main document there will be two lines with the Channel Category of "Sweet" and "Tart" and the Channel Support of "Multiple". But here is where it gets tricky. When the "Sweet" or "Tart" Channel Category are selected, it would populate the detail worksheet with the detail of what it represents. "Sweet" and "Tart would represent static lists of Channel Categories and Channel Support.
The line items being created on the Detail worksheet would be exactly like the one on the main worksheet, with just the Channel Category and Channel Support columns updated with the actual Channel Category and Channel Support that "Sweet" or "Tart" represents. (shown in Detail worksheet above)
Is this something that can be done? Or is there another way to make it work?
Thanks for your help,
Ellen
Last edited:
