Prev: vlookup---using data outside the range specified in the formul
Next: validation
From: FredDave on 10 Mar 2010 06:18
Hi all. I have linked my 55 sheets to one which is great.
What i need to know now if possible.
Each sheet has the same question over 11 columns
Each row is dated and a numeric number from 1 - 10 in each row
Now on the master sheet where everything is linked, is there a way that
If i changed the date on the master sheet it would reflect the answers from
the row with that date?
At present the answers showing is for 01/03/10, but i would like to look at
the totals for 08/03/10 and show the answers from each sheet for that date.
I could have a sheet for each week, but im hoping there is a way that if i
change the date in my master sheet it wil pick up the dated row answers from
each sheet.
Hope you understand and can assist

Thankyou in advance
From: Don Guillett on 10 Mar 2010 09:17
Probably doable but maybe you could just have ONE worksheet and use
data>filter to see the breakdowns.
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:1B7A7852-75DA-4329-AAEB-445E1394D1FD(a)microsoft.com...
> Hi all. I have linked my 55 sheets to one which is great.
> What i need to know now if possible.
> Each sheet has the same question over 11 columns
> Each row is dated and a numeric number from 1 - 10 in each row
> Now on the master sheet where everything is linked, is there a way that
> If i changed the date on the master sheet it would reflect the answers
> from
> the row with that date?
> At present the answers showing is for 01/03/10, but i would like to look
> at
> the totals for 08/03/10 and show the answers from each sheet for that
> date.
> I could have a sheet for each week, but im hoping there is a way that if i
> change the date in my master sheet it wil pick up the dated row answers
> from
> each sheet.
> Hope you understand and can assist
>
> Thankyou in advance

 | 
Pages: 1
Prev: vlookup---using data outside the range specified in the formul
Next: validation