Dropdown list sep sheet?

Raysoc

Board Regular
Joined
Feb 10, 2009
Messages
227
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.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,612
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top