D
Dave
Is there a way to have a drop down list using data validation in file
"jobs.xls" sheet "Sheet 1" Cell C4 to select a contact from a list that is
in the file "parts.xls" sheet "contact" and fill in the corresponding cells
in "Jobs.xls". The list of contacts starts on row 3 and goes to row 48 now
but there will be more in the future. If there is another way to do this
other than data validation I am open to other ideas.
In "Job.xls" Sheet name is "Sheet 1"
C4 C5 C6 D6 E6 C7 D7 C8 C9
Contact Address City St Zip Phone Fax Map e-mail
In "Parts.xls" Sheet name is "contact"
B3 C3 D3 E3 F3 H3 I3 J3 K3
Contact Address City St Zip Phone Fax Map e-mail
Thanks
Dave
"jobs.xls" sheet "Sheet 1" Cell C4 to select a contact from a list that is
in the file "parts.xls" sheet "contact" and fill in the corresponding cells
in "Jobs.xls". The list of contacts starts on row 3 and goes to row 48 now
but there will be more in the future. If there is another way to do this
other than data validation I am open to other ideas.
In "Job.xls" Sheet name is "Sheet 1"
C4 C5 C6 D6 E6 C7 D7 C8 C9
Contact Address City St Zip Phone Fax Map e-mail
In "Parts.xls" Sheet name is "contact"
B3 C3 D3 E3 F3 H3 I3 J3 K3
Contact Address City St Zip Phone Fax Map e-mail
Thanks
Dave