Hi
OK, this is a bit clunky but here goes.
1) Home!B5 - create a data validation dropdown list referencing range U2:U16. This will enable you to directly select the channel heading.
2) Home!D5 - create a data validation dropdown list referencing range T2:T9
Make selections in both of those cells. Then try
You will have to update it for the extra columns that you want as I don't have access to the real headings, but hopefully you will get what I'm trying to do. It does open the file completely in Excel, but then shuts it down again. If you turn off the display, then it really shouldn't be a problem.
Good luck
rylo
Bookmarks