Comparing two cells in VBA

[10basetom]

I hope I can explain this clearly... I have a traffic log that I've put in a spreadsheet with three columns: Date, IP, and Traffic. I created a macro that turns this into a pivot table (on another sheet) that sums up the traffic by IP for the month. So far so good.

Now what I would like to do is delete the original sheet once I verify that the monthly traffic total in the pivot table matches that of the source data. I found that I can get to the pivot table's grand total with this command:

Please Login or Register  to view this content.

My question is: in VBA how do I sum the traffic numbers in the source sheet (column C), then compare the total with the pivot table total, and only delete the source sheet if the totals match?

Thanks,
Tom

[BrianB]

SOMETHING LIKE :-

Please Login or Register  to view this content.

[10basetom]

THanks for your help, Brian.

SOMETHING LIKE :-

Please Login or Register  to view this content.