sum the same model + same side + same #

**ttik** · 08-20-2008, 10:16 AM

hello guys!
any expert here willing to help me on this macro? pls have a look on those photos. thank you !!

original format (total / yield / model / stencil#)
http://img186.imageshack.us/img186/5720/64578568yd2.jpg

will like to have formula on column E and F. *juz ignore the blue color.
example #1, refering to the red color in the photo, the formula will extract the column D (side2 #1) into column E (side2)and F (#1)
http://img172.imageshack.us/img172/623/27446630eh3.jpg

if would be great if this step below can be generated onto different sheet.
the macro will look for same model (column C) which have same stencil (column E) and same # (column F), then sum the total of thatvalue(column A)
repeat the function for every models.

http://img360.imageshack.us/img360/1795/58703962ny6.jpg

**arthurbr** · 08-20-2008, 10:27 AM

Hi,
is "single side" the same as side1 ?

Is this the end result you need ? ( creating the sied and # column excluded)?

(See attachment)

BTW the resulting Pivot Table can go another sheet if needed

**ttik** · 08-20-2008, 10:39 AM

yap, single side is side 1.

that was awesome !!! just the pivot table will do....i thought i have to use macros + formulas...

would like you to give me this tutorial. so next time i can handle it by myself.

can i move the pivot table around the sheet or move to a new sheet?

thank you very much !!

**arthurbr** · 08-20-2008, 01:30 PM

You can move it to another sheet or create it at once on another sheet
To move, right-click on the PT, select " Select entire table"
Ctrl + X
Open another sheet
Ctrl + V
Voilà

As for the other way, select a cezll in your list
Data - Pivot Table
Follow the wizard
Cheers