I have an Excel Workbook with 4 worksheets. Each worksheet is assigned to group that works a specific region. LA/MS/AL, NC/SC/GA, KY/TN/IN and FL.
When someone a New Task entry, a drop down box picks the correct worksheet to update, assigns a task number to this entry and updates the worksheet.
The task number is used on an Assigned Task form and a Completed Task form to update each entry when it is Assigned and Completed.
Because each form creates an email, people are having to retype information that was already entered on the New Task Form. I would like to be able to use the Drop down box that picks the correct worksheet and the task number to pull the information off the spreadsheet to populate the repeating information so people do not have to type it every time.
Any help is greatly appreciated.
Thanks,
Pam
When someone a New Task entry, a drop down box picks the correct worksheet to update, assigns a task number to this entry and updates the worksheet.
The task number is used on an Assigned Task form and a Completed Task form to update each entry when it is Assigned and Completed.
Because each form creates an email, people are having to retype information that was already entered on the New Task Form. I would like to be able to use the Drop down box that picks the correct worksheet and the task number to pull the information off the spreadsheet to populate the repeating information so people do not have to type it every time.
Any help is greatly appreciated.
Thanks,
Pam