C
Cesar Urquidi
Hello,
I have a large worksheet with data.
Here are the columns:
Order # Employee Hrs.
1000 Mike 2
2000 Mike 1
1000 Paul 2
3000 Rose 3
8000 Mike 1
3000 Mike 2
1000 Rose 1
4000 Paul 1
7000 Jhon 3
5000 Rose 2
1000 Jhon 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
I would like to put this data on a chart, but before I do that I need to
summarize the data.
This is what (I think) I need to do:
1. Sort by "Order #".
2. Once sorted, create a "conditional formatting" or a formula to the entire
"Order #" column to select only one of the orders from each group of orders.
These order numbers then will be displayed on another page or sheet like this:
1000 2000 3000 4000 5000 6000 7000 8000 9000
3. The employees that worked on each one of the orders will appear as bars
displaying the hrs. they worked. (Please note that if an employee worked on
the same "order #" on two or more different dates, that needs to be added up,
otherwise the chart is going to have multiple bars for the same employee in
that "order #").
I know how to do this manually, but I would like to see if there is a way to
automate it, since I will be running this weekly, and I'm trying to create
sort of a template.
Help please!!!
Thank you,
Cesar Urquidi
I have a large worksheet with data.
Here are the columns:
Order # Employee Hrs.
1000 Mike 2
2000 Mike 1
1000 Paul 2
3000 Rose 3
8000 Mike 1
3000 Mike 2
1000 Rose 1
4000 Paul 1
7000 Jhon 3
5000 Rose 2
1000 Jhon 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
I would like to put this data on a chart, but before I do that I need to
summarize the data.
This is what (I think) I need to do:
1. Sort by "Order #".
2. Once sorted, create a "conditional formatting" or a formula to the entire
"Order #" column to select only one of the orders from each group of orders.
These order numbers then will be displayed on another page or sheet like this:
1000 2000 3000 4000 5000 6000 7000 8000 9000
3. The employees that worked on each one of the orders will appear as bars
displaying the hrs. they worked. (Please note that if an employee worked on
the same "order #" on two or more different dates, that needs to be added up,
otherwise the chart is going to have multiple bars for the same employee in
that "order #").
I know how to do this manually, but I would like to see if there is a way to
automate it, since I will be running this weekly, and I'm trying to create
sort of a template.
Help please!!!
Thank you,
Cesar Urquidi