greentom22
New Member
- Joined
- Sep 13, 2006
- Messages
- 6
Hi
I'm trying to figure out the easiest way to pre-populate cells based on a selection in a central cell above.
When a user selects a certain number in a drop-down box in a cell, I would like that selection to be automatically inserted into the new cells as a default.
A further wrinkle would be that these defaults would be inserted only if a cell in that row has a number entered.
So: If A1 = 24% (selected from drop down box)
Then C3 = 24% (automatically selected from drop down box but can be changed)
Only if A3 = 1 and not empty (ie user has selected to use this row.)
If A3 is empty, then B3 is empty.
So far I've done the whole sheet without using VBA & macros (I'm a amateur at VBA) but I have a feeling I'll need to use VBA to get this done. So please, as simple as possible would be great.
Thanks
GreenTom
I'm trying to figure out the easiest way to pre-populate cells based on a selection in a central cell above.
When a user selects a certain number in a drop-down box in a cell, I would like that selection to be automatically inserted into the new cells as a default.
A further wrinkle would be that these defaults would be inserted only if a cell in that row has a number entered.
So: If A1 = 24% (selected from drop down box)
Then C3 = 24% (automatically selected from drop down box but can be changed)
Only if A3 = 1 and not empty (ie user has selected to use this row.)
If A3 is empty, then B3 is empty.
So far I've done the whole sheet without using VBA & macros (I'm a amateur at VBA) but I have a feeling I'll need to use VBA to get this done. So please, as simple as possible would be great.
Thanks
GreenTom