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
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
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
--
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
