Hi,

I have a file with 2 worksheets in it. The first worksheet, provides a
list of charge numbers under a specified program. The second worksheet I am
using for as a timesheet template.

In the second worksheet, I created a list in one of the columns which
finds the list of charge numbers from the first worksheet. What I would like
to happen is once I pick one of these charge numbers, the next 2 or 3 columns
"automatically" pull relavant information from the first worksheet & insert
to specified cell.

For example:

Worksheet 1 - Tracking Charge # Sheet

Column 1 Column 2 Column 3
Charge # PO XYZ Status

1234 PO 4444 Active

Worksheet 2 - Timesheet


Column 1 Column 2 Column 3 Task
Charge # PO XYZ Status

Pick from list Pulls Info. from 1st
Job 1
of Column 1 from worksheet
(Attempting to

tracking that Job 1 is

being billed or

charged to its

correct charge number


I attempted a handful of formulas so far, but none of them seem to fully
work yet.

Please assist.


Thank you....