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
sorry for the size 47.8 mb
zipped version 5.2 mb