Hi,

Let me explain what I am trying to do.

I have a 2 sheet workbook Sheet1 = (Data) is a pivot table ,Sheet2(Saved)

I am trying to create a macro that works with my pivot table. The problem is when I record my macro I start on sheet1 to double click the value in cell B3 it automatically opens up sheet3( sheet3 is all of the person work for that day) So I want to insert 3 lines and count or sum all the cells in the ranges A3:A500 for coulmns A,B,C,D and E .I then want to copy all the calculations just made (sheet3 cells A1:A5) then paste special the values to sheet2(saved) then Delete sheet3 and return to sheet1 to start all over again at B4 and so on till it hits an empty cell on sheet1 (data).

Can someone help me with this code:

Thank You So Much...

Please Login or Register  to view this content.