'!C2,0)
>> +IF(AND(22>=DAY($E$3),22<=DAY($G$3)),'22'!C2,0)
>> +IF(AND(23>=DAY($E$3),23<=DAY($G$3)),'23'!C2,0)
>> +IF(AND(24>=DAY($E$3),24<=DAY($G$3)),'24'!C2,0)
>> +IF(AND(25>=DAY($E$3),25<=DAY($G$3)),'25'!C2,0)
>&
; +IF(AND(23>=DAY($E$3),23<=DAY($G$3)),'23'!C2,0)
>> +IF(AND(24>=DAY($E$3),24<=DAY($G$3)),'24'!C2,0)
>> +IF(AND(25>=DAY($E$3),25<=DAY($G$3)),'25'!C2,0)
>> +IF(AND(26>=DAY($E$3),26<=DAY($G$3)),'26'!C2,0)
>> +IF(AND(27>=DAY($E$3),27<=
7;28'!C2,0)
+IF(AND(29>=DAY($E$3),29<=DAY($G$3)),'29'!C2,0)
+IF(AND(30>=DAY($E$3),30<=DAY($G$3)),'30'!C2,0)
+IF(AND(31>=DAY($E$3),31<=DAY($G$3)),'31'!C2,0)
I put it in Cell C7 of your Consolidate sheet and copied it across and down.
It's not pretty, but it works.
Paul
-
can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Rajesh thrissur
To: excel-macros@googlegroups.com
Sent: Thu, January 24, 2013 1:23:06 AM
Subject: Re: $$Excel-Macros$$ Consolidate data from 3
e places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> -
>>
>>
>>
>>
>>
>> From: kasper
>> To:
places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
>
>
>
> From: kasper
> To: excel-macros@googlegroups.com
> Sent: Tu
gt; -------------
>
>
>
>
> ________
> From: kasper
> To: excel-macros@googlegroups.com
> Sent: Wed, January 23, 2013 9:40:29 AM
> Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master
>
> shee
_
From: kasper
To: excel-macros@googlegroups.com
Sent: Wed, January 23, 2013 9:40:29 AM
Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master
sheet
Hi Paul
Date is in the consolidation page there i give it under the heading from
01/01/13 to 05/01/13
Regards
--
> *From:* kasper >
> *To:* excel-...@googlegroups.com
> *Sent:* Tue, January 22, 2013 8:13:42 AM
> *Subject:* Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one
> master sheet
>
> Hi Paul
>
> Thanks for the idea you gave. Is there any way to a
From: kasper
To: excel-macros@googlegroups.com
Sent: Tue, January 22, 2013 8:13:42 AM
Subject: Re: $$Excel-Macros$$ Consolidate data from 31 sheets to one master
sheet
Hi Paul
Thanks for the idea you gave. Is there any way to add date criteria also there
eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13.
W
Hi Paul
Thanks for the idea you gave. Is there any way to add date criteria also
there eg: 01/01/13 to 05/01/13 or 01/01/13 to 10/01/13.
With regards and thanks
Rajesh kainikkara
On Tuesday, January 22, 2013 6:28:14 PM UTC+5:30, Paul Schreiner wrote:
>
> Because no two people have the same fi
Because no two people have the same file format or requirements, there really
isn't a single solution to fit all needs.
HOWEVER:
IF all of the data sheets are in the same format and
IF all of the data sheets have all entries
Basically, if the value for "Cola" "Op STK" is always in cell C2
or ev
12 matches
Mail list logo
