Prev: Change format
Next: date format
From: Laddie on 15 Mar 2010 15:49
Basically I am looking to take data from a list and have it automatically
place itself into a schedule.

The data would be extracted and placed based on the date the work is to be
performed and then by the crew to perform the work. Ideally I would like it
to be able to fill in based on hours associated with the job being assigned.

job number job name Crew Date Hrs
2002 M10, M11, M12 AMRI 212 3/15/10 1.00
2002 M10, M11, M12 AMRI 251 3/16/10 1.50


I then want to take this information and have it fill in a schedule with
colors for the cells showing the job #'s:

3/15/2010 3/16/2010
212 6:00 AM 2002
212 7:00 AM
251 6:00 AM 2002
251 7:00 AM 2002

Any thoughts would be great.

Thanks

--
Laddie
From: Don Guillett on 16 Mar 2010 09:23
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Laddie" <Laddie(a)discussions.microsoft.com> wrote in message
news:41AF1D9B-FDDB-4D98-8620-E63C74D93841(a)microsoft.com...
> Basically I am looking to take data from a list and have it automatically
> place itself into a schedule.
>
> The data would be extracted and placed based on the date the work is to be
> performed and then by the crew to perform the work. Ideally I would like
> it
> to be able to fill in based on hours associated with the job being
> assigned.
>
> job number job name Crew Date Hrs
> 2002 M10, M11, M12 AMRI 212 3/15/10 1.00
> 2002 M10, M11, M12 AMRI 251 3/16/10 1.50
>
>
> I then want to take this information and have it fill in a schedule with
> colors for the cells showing the job #'s:
>
> 3/15/2010 3/16/2010
> 212 6:00 AM 2002
> 212 7:00 AM
> 251 6:00 AM 2002
> 251 7:00 AM 2002
>
> Any thoughts would be great.
>
> Thanks
>
> --
> Laddie

 | 
Pages: 1
Prev: Change format
Next: date format