D
Dallas Green
I am working with two different types of schedules. They are both in
separate workbooks. I would like to automatically update schedule #2 with
the dates from schedule #1. The dates are in rows with the jobs listed below
them on schedule #1. Is it possible to have schedule #2 search for the job
number in schedule #1 under the date heading and fill in the appropriate date
in schedule #2. So what is boils down to is that schedule #1 is the date is
row 1 and a name in column A and then job number fills in for the appropriate
name and date. In Schedule #2 is the job # in column A and date in column B
but I want that date to automatically update from schedule #1 so I don't have
to search through schedule #1 to fill it in. Thanks.
separate workbooks. I would like to automatically update schedule #2 with
the dates from schedule #1. The dates are in rows with the jobs listed below
them on schedule #1. Is it possible to have schedule #2 search for the job
number in schedule #1 under the date heading and fill in the appropriate date
in schedule #2. So what is boils down to is that schedule #1 is the date is
row 1 and a name in column A and then job number fills in for the appropriate
name and date. In Schedule #2 is the job # in column A and date in column B
but I want that date to automatically update from schedule #1 so I don't have
to search through schedule #1 to fill it in. Thanks.