Hi guys, hoping this can be acomplished.
I have a workbook that has 10+ worksheets. This workbook and worksheet is pumped out from Access tho this is NOT an access question, just giving enough information.
I am modifying the workbook afterwards, one of the mods I need to do is add 20+ columns to each sheet. Not a problem I can automate this via macro which I did.
But then I realized that for these new columns they require drop down boxes, and for the template the data for them is stored in the same sheet. Now if I do this its going to make each sheet wayyy too long and make the file way too big. Is there no way for me to reference another sheet to populate the drop down boxes?
For example EVERY worksheets column L will need a drop down box compromised from the data in Lists!A2:A5.
I was then going to make lists hidden as there is no need for the end user to see the sheet, I just want them to be able to use the drop down boxes.
I have a workbook that has 10+ worksheets. This workbook and worksheet is pumped out from Access tho this is NOT an access question, just giving enough information.
I am modifying the workbook afterwards, one of the mods I need to do is add 20+ columns to each sheet. Not a problem I can automate this via macro which I did.
But then I realized that for these new columns they require drop down boxes, and for the template the data for them is stored in the same sheet. Now if I do this its going to make each sheet wayyy too long and make the file way too big. Is there no way for me to reference another sheet to populate the drop down boxes?
For example EVERY worksheets column L will need a drop down box compromised from the data in Lists!A2:A5.
I was then going to make lists hidden as there is no need for the end user to see the sheet, I just want them to be able to use the drop down boxes.