: 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
World Class
Hi,
I want to know how we can consolidate data in different worksheets into one
worksheet.
Regards
Smitha/ Senior Finance Executive
Speridian%20Logo
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
mailto:smitha.kum...@speridian.com
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
, 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 last used row
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
or do a
summary from different sheets?
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* smitha.kumari smitha.kum...@speridian.com
*Sent:* Tuesday, November 08, 2011 10:38 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Consolidate data in different work sheets
: 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 Sheet1 B6 copy