auto update pivot table and/or filters when data changes?

I've been told that a VBA script might be able to do this for me?
but I really don't know anything about VBA stuff
I have a a few data entry cells on page 1
a data logged worksheet on page 2 that is a copy and paste page from the end user
some lookup tables on page 3
and a pivot table on page 4

when the user changes the values on page 1 or 2 I would like it to auto update the Pivot table so that the graph based of of the pivot table changes accordingly right away with no extra user input
can anybody help me with this as I don't even know where to start with it


heres the worksheet if anybody is interested in seeing to to understand what I need it to do..
for now I made a macro...but I would like it to do this automatically and with changing pages...
I would like it even better if I could hide the pivot table page so the end user couldn't see it..but I understand and its not that big of a deal if it has to be visible

http://www.audiohelix.com/excel/HP%20TQ%20Instant.xls
sorry for the size 47.8 mb

zipped version 5.2 mb
http://www.audiohelix.com/excel/HP%20TQ%20Instant.zip

I do not use pivot tables

If the macro code within Macro1 is all that you need to run when the changes are made then try this


'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

You will need a copy of the macro in both sheets

The pivot table sheet can be hidden without affecting the macro