26th May 2011, 11:42 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
I know Data Validation can be added in 2003 but i think it needs 2003 to do it, i have added a link on where to find it.
http://www.keystonelearning.com/res...alidation_rules
Instruction
1) Select E12 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AH$2:$AH$50 then press "OK"
2) Select E28 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AH$2:$AH$50 then click "Error Alert" tab and uncheck the box press "OK"
3) Select Z28 go to Data Validation in the Allow box select "list" in the source box put this in =Database!$AJ$2:$AJ$50 then click "Error Alert" tab and uncheck the box press "OK"
When this is all done save the document it should work now.
The only other thing is i removed code on the database sheet to reduce the size of the file so the formulas only go down to 2000 not 50000 you will have to extend them if you want more. |