I have a workbook with some worksheets. I want a drop down on a separate/new worksheet that contains the worksheet names.
Based on this selection I then want another drop down on this new sheet to contain the data in the first row of thae sheet (the heading row) selected from drop down 1.
Based on this I can then finally have a last drop down that contains the actual data in the column selected from drop down 2.
At the moment I can't even see how to get a drop down to refer to data on another sheet. Is this possible before I waste my time? Can I only do this via VB?
Thanks in advance
I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams
Based on this selection I then want another drop down on this new sheet to contain the data in the first row of thae sheet (the heading row) selected from drop down 1.
Based on this I can then finally have a last drop down that contains the actual data in the column selected from drop down 2.
At the moment I can't even see how to get a drop down to refer to data on another sheet. Is this possible before I waste my time? Can I only do this via VB?
Thanks in advance
I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams