merging sheets
 

I have a spreadsheet to check which products are being sampled but instead of
having seven different sheets for each day i just want one sheet.
example

A1 Will have a drop down list with days of the week

Received sampled
Percentage
A5 High risk products 100 0
A6 Medium Risk Products 20 0
A7 Low Risk Products 10 0


I want to be able to pick the day from the drop down list in A1 and check
the totals without having to continuosly check different sheets (so by
selecting monday it will bring up mondays data to be edited or checked , then
tuesday wednesday etc)

Hope this makes sense to someone

Thanx for any help

merging sheets
 

You need to have an extra column to record the day, then you can apply
autofiliter to this column to select the day of interest. Instead of
SUM(range) you would use SUBTOTAL(9, range) somewhere outside the
scope of the filter (eg in the top row above your headings) to show
the totals of the visible cells.

Hope this helps.

Pete

On Sep 16, 10:30*am, cufc1210
wrote:
I have a spreadsheet to check which products are being sampled but instead of
having seven different sheets for each day i just want one sheet.
example *

A1 *Will have a drop down list with days of the week

* * * * * * * * * * * * * * * * * * * * * * Received * * * *sampled * *
Percentage
A5 *High risk products * * * * * * * 100 * * * * * * * * *0
A6 *Medium Risk Products * * * * *20 * * * * * * * * * 0
A7 *Low Risk Products * * * * * * * 10 * * * * * * * * * 0

I want to be able to pick the day from the drop down list in A1 and check
the totals without having to continuosly check different sheets (so by
selecting monday it will bring up mondays data to be edited or checked , then
tuesday wednesday etc)

Hope this makes sense to someone

Thanx for any help

merging sheets
 

im lost now, think i need to go back to computer school

"Pete_UK" wrote:

You need to have an extra column to record the day, then you can apply
autofiliter to this column to select the day of interest. Instead of
SUM(range) you would use SUBTOTAL(9, range) somewhere outside the
scope of the filter (eg in the top row above your headings) to show
the totals of the visible cells.

Hope this helps.

Pete

On Sep 16, 10:30 am, cufc1210
wrote:
I have a spreadsheet to check which products are being sampled but instead of
having seven different sheets for each day i just want one sheet.
example

A1 Will have a drop down list with days of the week

Received sampled
Percentage
A5 High risk products 100 0
A6 Medium Risk Products 20 0
A7 Low Risk Products 10 0

I want to be able to pick the day from the drop down list in A1 and check
the totals without having to continuosly check different sheets (so by
selecting monday it will bring up mondays data to be edited or checked , then
tuesday wednesday etc)

Hope this makes sense to someone

Thanx for any help