Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel help?
gerturdeanna
Posts: 4,350
Forumite
in Techie Stuff
Morning all.
You always manage to let me know what I need to do so I've come begging again!!
I'm creating a excel s/sheet at work and I want to bring back specific data in one column dependant on what has been selected in the column before.
For example, if white is selected(from a data validation list), I want the next column to only allow me to choose size 8,10,12 etc (again preferablly from a data validation).
Is this possible? Have I explained myself properly?
Thanks in advance
Gert x
You always manage to let me know what I need to do so I've come begging again!!
I'm creating a excel s/sheet at work and I want to bring back specific data in one column dependant on what has been selected in the column before.
For example, if white is selected(from a data validation list), I want the next column to only allow me to choose size 8,10,12 etc (again preferablly from a data validation).
Is this possible? Have I explained myself properly?
Thanks in advance
Gert x
Made it - 15 years married!! Finally!! xx:beer:
0
Comments
-
What you need is called cascading validation.
Google has a load of tutorials and tips/tricks to get you started.
It's easier to follow the tutorials rather than trying to explain on here.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0 -
Thank you - I knew there would be a way of doing it! I'll google under that reference.
ThanksMade it - 15 years married!! Finally!! xx:beer:0 -
I've always called it Dependant Validation. The premise being that you name your dependant lists - in this case the Sizes - using the precedent values - in this case the Colours.
Setup the following lists and name the ranges as per the headers
Colours
Red
White
Blue
Red
2
4
6
White
8
10
12
Blue
16
18
20
Setup the validation in the first column as normal using the named range 'Colours'. Then in the second column, instead of entering a named range you need to use the =INDIRECT function to select the value selected in the first column. Remember to ensure that the row reference is relative.0 -
You could always ask on here
http://www.mrexcel.com/forum/index.php0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 356K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.3K Spending & Discounts
- 248.5K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards