G
Guest
Hello
I have a daily file with hourly production information divided in sections
for different plants.
A1= "Daily Production Report mm/dd/yyyy Acme Industrial"
The sections are laid out as follows:
Starting on row3
First Row: ColA is Plant Name
Then a line for each supervisor with hourly entries in ColB:Y
Then a TOTAL line.
I would like to be able to enter plant name and then generate a summary(New
File) that would show each supervisor and their hourly totals. It would look
something like:
1 2 3 4... 24
08/01/2006 Bill
Scott
George
Tyler
08/02/2006 Scott
Jim
I hope this is not too confusing. I will glaly repost additional
information to clarify.
Thanks!
I have a daily file with hourly production information divided in sections
for different plants.
A1= "Daily Production Report mm/dd/yyyy Acme Industrial"
The sections are laid out as follows:
Starting on row3
First Row: ColA is Plant Name
Then a line for each supervisor with hourly entries in ColB:Y
Then a TOTAL line.
I would like to be able to enter plant name and then generate a summary(New
File) that would show each supervisor and their hourly totals. It would look
something like:
1 2 3 4... 24
08/01/2006 Bill
Scott
George
Tyler
08/02/2006 Scott
Jim
I hope this is not too confusing. I will glaly repost additional
information to clarify.
Thanks!