Prev: rename worksheet tabs
Next: Sumproduct for Values over a certain Value eg 0.00
From: FredDave on 15 Mar 2010 19:49
I have 5 sheets, Heath, Gary, John and Fred.
They go to their sheet
Heading: Date Question1 Question2 Question3
They ent 3/3 5 6 1

They enter a date for each monday its filled out. then enter a number
between 0 and 10.

I have a mastersheet. It has the same heading as above but with the sheet
name in column b

What i would like is in the master sheet is if in column4 row1 cell a date.

How can i change the date in col 4 row 1 that when it looks at the other
sheets it will display only the figures for that date?

Hope you understand and can help.

Thankyou
From: Don Guillett on 16 Mar 2010 09:33
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"FredDave" <FredDave(a)discussions.microsoft.com> wrote in message
news:0B8D754E-37E1-4D3B-B201-BB2FA6117243(a)microsoft.com...
>I have 5 sheets, Heath, Gary, John and Fred.
> They go to their sheet
> Heading: Date Question1 Question2 Question3
> They ent 3/3 5 6 1
>
> They enter a date for each monday its filled out. then enter a number
> between 0 and 10.
>
> I have a mastersheet. It has the same heading as above but with the sheet
> name in column b
>
> What i would like is in the master sheet is if in column4 row1 cell a
> date.
>
> How can i change the date in col 4 row 1 that when it looks at the other
> sheets it will display only the figures for that date?
>
> Hope you understand and can help.
>
> Thankyou

 | 
Pages: 1
Prev: rename worksheet tabs
Next: Sumproduct for Values over a certain Value eg 0.00