Drop down box list based on response to another drop down box

Phideaux · #1 04-12-2018, 08:14 AM

Quote:

Originally Posted by p45cal

Yes, see attached.
You should be able to hide the Stuff sheet
Because you use Excel 2003 I've had to add an extra named range (NPS_Size) because Excel 2003 doesn't seem to like data validation referring directly to another sheet.

Bingo! That was the initial issue that I was experiencing. While I could "hide" the tabular data, I'm prone to forget where I put it! (I'm old, ask my dinosaur)

And again, "Thanks!"

EDIT: Yikes!

I just opened your last sheet. The functionality of the front page is gone. It lists the values, but there's no way to change/select the values anymore.

I'm beginning to wonder if my Excell program is coming undone.

p45cal · #2 04-13-2018, 03:07 AM

Quote:

Originally Posted by Phideaux

B Yikes!

I just opened your last sheet. The functionality of the front page is gone. It lists the values, but there's no way to change/select the values anymore.

I'm beginning to wonder if my Excell program is coming undone.

I opened my attachment and there was no data validation! I don't know why.
Hopefully the attached, where I've re-instated the data validation, works now. It was done on a machine with Excel 2003.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Drop down lists and pulling data from worksheet based on drop down selection	cjoyce73	Excel	5	07-17-2017 07:40 AM
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list	Irimi-Ai	Word	5	04-25-2017 09:31 AM
Use different sumifs based on value in drop down.	Prondr	Excel	3	12-20-2016 07:05 AM
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM