I am attempting to revamp a "Job Change Request" Form.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Would appreciate your outstanding tutelage if at all possible.
<o></o>
Specifically:
<o></o>
1) Is there a way to auto-fill several columns based upon a selection of a single variable?
Example:
Sheet1 is the request form
Sheet2 contains Lists
Sheet3 has records
On Sheet1, in cell A6, you select a Job from a List on Sheet2, and by selecting that job, cells B6 thru E6 (on sheet1) are automatically filled in with other data on sheet3 that corresponds with that Job.
Thanx -
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>Would appreciate your outstanding tutelage if at all possible.
<o
></o>Specifically:
<o
></o>1) Is there a way to auto-fill several columns based upon a selection of a single variable?
Example:
Sheet1 is the request form
Sheet2 contains Lists
Sheet3 has records
On Sheet1, in cell A6, you select a Job from a List on Sheet2, and by selecting that job, cells B6 thru E6 (on sheet1) are automatically filled in with other data on sheet3 that corresponds with that Job.
Thanx -
