HTH
if you have data in same format on multiple worksheets and you want to
compile on a single sheets you can Use this Macro,
Sub ConsolidateAllSheets()
Dim wksConsolidate As Worksheet
Dim wksSheet As Worksheet
Dim lngLastRow As Long
Set wksConsolidate = ThisWorkbook.Worksheets.Add
lngLastRow = 1
Application.DisplayAlerts = False
On Error Resume Next
ThisWorkbook.Worksheets("Consolidated").Delete
On Error GoTo 0
wksConsolidate.Name = "Consolidated"
If Not ThisWorkbook.ProtectStructure Then
With wksConsolidate
For Each wksSheet In ThisWorkbook.Worksheets
If Not wksSheet Is wksConsolidate Then
wksSheet.UsedRange.Copy .Range("A" & lngLastRow)
lngLastRow = .UsedRange.Rows.Count + 1
End If
Next wksSheet
End With
End If
MsgBox "Done"
End Sub
http://excelpoweruser.blogspot.in/2012/06/compile-worksheets.html
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Gawli
Sent: 13 June 2012 5:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sheet Requirements
see the attached sheet
On Wed, Jun 13, 2012 at 5:43 PM, Deba Ranjan <drdeva...@gmail.com> wrote:
Thanks... Don bro, But still i have confusion on the coding. can
you please share with the attachment ?
i hope i will get more ideas on attached.
thanks for that.
Thanks & Regards,
Deba Ranjan P
On Wed, Jun 13, 2012 at 5:30 PM, dguillett1 <dguille...@gmail.com> wrote:
sub cs()
'assumes your master sheet is the FIRST sheet
dim I as long
for I =2 to sheets.count
sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2)
next i
end sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan <mailto:drdeva...@gmail.com>
Sent: Tuesday, June 12, 2012 11:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sheet Requirements
Thanks...........
Thanks & Regards,
Deba Ranjan P
On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay <mangesh.da...@gmail.com>
wrote:
Hi Dear,
It happens with everybody specially when someone tries to learn new concepts
of IT or any other topic. So keep going and this group is good to help you.
MangeSH
On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan <drdeva...@gmail.com> wrote:
Thanks.
i love excel very much, Actually i keep on trying the coding But
really i am so sorry that i really don't have this Idea. i purchased books
for VBA macros and Excel, and i am trying my best to do so. Actually i am
very new to this concepts (Means VBA coding). And even i am trying to learn
from this group as well.
I adopted to learn one by one. Let me tell you honestly, i have no
system at my home. And what ever i learn, i learnt at Office but that too
also i have many few times to learnt myself. So its my drawback.
i hope i would able very few things a day, Any way thanks for
suggesting that. i will keep trying. i have very confusion in coding when i
go trough the books. Like String, long etc. ........................
Thanks & Regards,
Deba Ranjan P
On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 <dguille...@gmail.com> wrote:
Forgive me but as I recall you have been a part of this group for awhile. If
so, you should have learned enough to do this yourself.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan <mailto:drdeva...@gmail.com>
Sent: Tuesday, June 12, 2012 6:45 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sheet Requirements
Dear Experts,
i have attached a file which contains many sheets. in every sheets there
contains data. i want a button which on clicking the whole sheet data
consolidated. Please find the attached.
thanks...........................
Thanks & Regards,
Deba Ranjan P
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>
--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
