,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Rajesh thrissur
To: excel-macros@googlegroups.com
Sent: Fri, Januar
; +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
Dear Abhidha,
Try it..
before run the macro, please check on Tools-Reference-Microsoft Runtime
Scripting
Change path and range as per your need
Sub Consodilate_workbook()
Dim wb As Workbook
Dim rng As Range
Dim fil AsFile
Dim i As Long
Dim fld As Folder
Set wb =
com
From: smitha.kumari
Sent: Thursday, November 10, 2011 12:51 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Consolidate data in different work sheets
Hi Haseeb,
This will not consolidate the name , only the hours. Isn’t it?
Regards
Smitha/ Senior Finance Executive
Wo
om
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Haseeb Avarakkan
Sent: Thursday, November 10, 2011 12:02 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Consolidate data in different work sheets
Hello Smitha;
Use this in Sheet
if you just want to do a sum of all the same cells across multiple sheets,
you could use something like this
=SUM(Sheet2:Sheet5!A2)
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:59 PM, dguillett1 wrote:
> Do you want to copy a range from each sheet to a master or do a
> summary from
Do you want to copy a range from each sheet to a master or do a summary from
different sheets?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: smitha.kumari
Sent: Tuesday, November 08, 2011 10:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Consolidate data in diff
esday, November 09, 2011 2:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Consolidate data in different work sheets
Sub method2()
Dim i, j, k, s As Long
s = Sheets.Count
Sheets.Add After:=Sheets(Sheets.Count)
For i = 1 To s
Sheets(i).Select
j = 2
' it will copy till las
Sub method2()
Dim i, j, k, s As Long
s = Sheets.Count
Sheets.Add After:=Sheets(Sheets.Count)
For i = 1 To s
Sheets(i).Select
j = 2
' it will copy till last used row automatically
k = ActiveSheet.UsedRange.Rows.Count
Rows(j & ":" & k).Copy
Sheets(Sheets.Count).Select
Sheets(Sheets.Count).Range("a65
Hi Rajesh,
Find herewith the attachment for deriving result by using single cell
formula.
Guys don't use / suggest helper column / array formula unnecessarily.
Hope that make sense.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Wed, May 11, 2011 at 2:08 AM, Rajesh K R wrot
Simply use the sumifs formula
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Wednesday, May 11, 2011 2:54 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Consolidate data
Please see attached file
By
Hi,
Thank you everybody send reply, all are perfect answers.
Regards
Rajesh kainikkara
On 5/11/11, ChilExcel wrote:
> Please see attached file
>
>
>
> By Chilexcel
>
> 2011/5/10 Rajesh K R
>
>> Hi Experts
>> Pls check the attached file and tell me how to consolidate date month
>> wise.
>>
>>
Please see attached file
By Chilexcel
2011/5/10 Rajesh K R
> Hi Experts
> Pls check the attached file and tell me how to consolidate date month wise.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
> Some importan
check the attachemnt
see if it helps
On Wed, May 11, 2011 at 2:08 AM, Rajesh K R wrote:
> Hi Experts
> Pls check the attached file and tell me how to consolidate date month wise.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> -
24 matches
Mail list logo
