J
Jimmy Joseph
Hello,
I have the following data in xls.
Description Investment (Fulfillment) (PTU) (Fulfillment (PTU)
(2006 Qtr) (2007 Qtr)
Griding M/c 2000 IV III
Lathe M/c 500 II IV
Cutting M/c 200 I II
Now i would like to have a summary in a different sheet in the same work
book as below
(Year) (Fulfillment) (PTU)
2006 QtrI
QtrII 500
QtrIII
QtrIV 2000 500
Similarly i need the summary for Year 2007 also
My data in (fulfillment) (PTU) keeps changing based on the delivery
shedule of machinery. I want excel to make changes in summary sheet as
per the updation in (fulfillment) (PTU) column values (data is
represented as quarters in year)
What is the formula i have to use for this purpose.
Help please!
Regards,
Jimmy JOseph
I have the following data in xls.
Description Investment (Fulfillment) (PTU) (Fulfillment (PTU)
(2006 Qtr) (2007 Qtr)
Griding M/c 2000 IV III
Lathe M/c 500 II IV
Cutting M/c 200 I II
Now i would like to have a summary in a different sheet in the same work
book as below
(Year) (Fulfillment) (PTU)
2006 QtrI
QtrII 500
QtrIII
QtrIV 2000 500
Similarly i need the summary for Year 2007 also
My data in (fulfillment) (PTU) keeps changing based on the delivery
shedule of machinery. I want excel to make changes in summary sheet as
per the updation in (fulfillment) (PTU) column values (data is
represented as quarters in year)
What is the formula i have to use for this purpose.
Help please!
Regards,
Jimmy JOseph