I run a daily report of all system data in WIP.
I then insert the Pivot Table to show the totals for each P/N in WIP.
When I run the report the next day, do I have to rerun the Pivot table?
Meaning, delete the Tab in the Wrkbook, reset another.
New lines can be added with new P/N's etc.
Or is there a way to REFRESH the data without rerunning the PT?
I then insert the Pivot Table to show the totals for each P/N in WIP.
When I run the report the next day, do I have to rerun the Pivot table?
Meaning, delete the Tab in the Wrkbook, reset another.
New lines can be added with new P/N's etc.
Or is there a way to REFRESH the data without rerunning the PT?