excel - dd list update another cell

[davejam]

Hi all,

I'm quickly trying to throw something together and i'm just trying to simplify entry....

I'm creating a simple tax sheet, I want a dropdown for year with only 2 entries (2007/2008), when i select one of these i want to update some other cells with the values for that year... these do not have to be dynamic as the values for each year are static.

i have created a list by going to data->validation and selecting 'list', pointing the source to named cells on another worksheet (simply containg '2007', '2008')

haven't used vba for excel to any degree so am now stumped....

if my list cell was b1, and the cell i want to update is b4, is there some code i can create that runs on selection of a year that is a simple if that will populate...

ie.
if b1 = 2007 then
b4 = 500
else
b4 = 800
end if

possible??

cheers


daveJam

*two wrongs don't make a right..... but three lefts do!!!!*

 

[SkipVought]

Hi,

Use Data/Validation to select the year.

NAME that cell (my prefeence).

Have all other cells reference that name/cell. (no if formula necessary)

Skip,

_[red][/red]