Validation List

T

The Todal

Board Regular
Joined
Jan 2, 2007
Messages
129
I'm trying (without success) to figure out how to make the validation list in B1 subject to the item selected in A1. Any suggestions? TIA
 
Sort by date Sort by votes
More than welcome.

Never got to Carnoustie, went to Kendal instead. One of my mates just bought a farm stead so he wanted some free advice on what to do.

Hope you're enjoying the fine golfing action.

Kindest Regards


Dave
 
Upvote 0

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
And you don't need to put the second drop down downwards you can condense the data
Book1 (version 1).xls
ABCDEFG
1
2
3
4Rep1abcde
5Rep2fghij
6Rep3klmno
7Rep4pqrst
8
923456
10abcde
11
12Rep1a
13
Sheet1
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Show Data Validation Lists in Next Row of Table
Replies
0
Views
438
AndyPandy27
A
N
  • Question
Worksheet Event adding and removing Data Validation based on multiple Conditions
Replies
0
Views
255
Nathan Asius
N
N
  • Question
Multiple Conditional Data Validations
2
Replies
13
Views
694
Nathan Asius
N
L
  • Question
A way to search by name or number in a data validation list and only return the name in that cell and the associated number in the adjacent cell?
Replies
2
Views
287
SunnyAlv
SunnyAlv
C
  • Solved
Source Formatting from a Data Validation
2
Replies
10
Views
240
CantExcel123
C

Forum statistics

Threads
1,215,054
Messages
6,122,895
Members
449,097
Latest member
dbomb1414

Share this page

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
Back
Top