Hi,

I have two sheets in excel,

sheet1 is the source data, where the count of the data keep changes.
sheet2 is the pivot sheet, where pivot is allready created.

I need a excel macro code, to update my pivot every day, when i run macro.
Update means, As in sheet1 the count of row keep changing the macro first it
should check the count in sheet1 then, the macro should update the same row
count in pivot.
Macro should do the changes in existing pivot, it should not create a new
pivot.

Please help me...