Copy Range
 

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!

Copy Range
 

Email me a dummy worksheet with one sheet as raw data and another as
formatted data and I'll see what I can do.

Charles Chickering


George wrote:
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!