Pulling information from a worksheet into a user form
 

I have an Excel Workbook with 4 worksheets. Each worksheet is assigne
to group that works a specific region. LA/MS/AL, NC/SC/GA, KY/TN/IN an
FL.

When someone a New Task entry, a drop down box picks the correc
worksheet to update, assigns a task number to this entry and update
the worksheet.

The task number is used on an Assigned Task form and a Completed Tas
form to update each entry when it is Assigned and Completed.

Because each form creates an email, people are having to retyp
information that was already entered on the New Task Form. I would lik
to be able to use the Drop down box that picks the correct workshee
and the task number to pull the information off the spreadsheet t
populate the repeating information so people do not have to type i
every time.

Any help is greatly appreciated.

Thanks,
Pa

--
Message posted from http://www.ExcelForum.com