PDA

View Full Version : Solved: Pivot Table



coliervile
07-01-2006, 04:06 PM
Is there any benefit of having a pivot table in a VBA code over Excels-Data-Pivot Table on the tool bar? If so I would appreciate someones help/assistance writing one. I have a userform that is opened on worksheet1- "OvertimeEntry", "Click here to open Overtime Form" that the data is entered on and then updates the database, located on "OvertimeDatabse worksheet (Thank you mdmackillop for you help). When the form is complete I wouild like the "Add Overtime" button on the userform, when clicked, to update the "OvertimeDatabase" and the pivot table. Currently the pivot table is updated by clicking the "Click here to view and update Overtime Totals" button on worksheet1, OvertimeEntry. Any assistance is greatly appreciated.