My wife says that I expect people tpo know what I am thinking without me
telling them.......


I forgot to add that I hid the sheet with the pivot table and had a Results
sheet for the staff in which the cells were linked to the Pivot table cells.
The Table in the Staff sheet therefore was set out and formatted to look
*user friendly* and the staff did not feel intimidated by it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"AndyJ" wrote in message
...
Spreadsheet is already using pivot tables to give me the results I need
but was hoping to come away form that option and also not to use
autofilter - I unfortunately have staff at other locations who have very
basic excel knowledge so have to present the data as simply as possible
so that when they open the spreadsheet they can just see the results
without having to manipulate the data in any way.

When I was at work I wrote a spreadsheet for people who had very basic
knowledge. I put in place holding hidden entries as place holders so
that the Pivot table would not alter if there was not full data entered,
set the range bigger than ever would be used and wrote a Macro to refresh
the Pivot Table.

The staff then just had to add data and then click on a button to get the
updated result.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk