Hiding Your Data Entry Work

[warhammer486]

I use a variety of spreadsheets at my office, and I may have figured this out already, but I wanted to get other people's ideas for maybe a fresh look at something...

I am working on a spreadsheet where I want the recipients to see the results of the data in a table showing average discounted prices between competing locations, what they advertise to the public on their website. Initially I was using a calculator on my PC to add up about 20-25 prices, average them, and then type in the results on the chart. Then I figured it would be faster for me just to enter in the raw data in a row on another sheet/tab and then have the cell from the main table just show the totals. To keep track of what I am entering, I am using a sheet/tab for each type of product, totaling up to about fifteen additional sheets/tabs. I then hide those sheets from the recipients so all they see is the final average totals in a table.

My question is if there is an easier/more convenient way to hide the data, or perhaps the recipients will want to see the raw entries and rather than reveal the other sheets, there may be a cleaner way for them to see it. I am not familiar with pivot tables or anything like that, so I was unsure if there is another way to accomplish what I am doing.

Thanks!

 

[Scott Huish]

You could just Copy the results page and Paste Special Values into a blank spreadsheet and send them that instead of the one you have working data on.