________________________________
From: ravinder negi <ravi_colw...@yahoo.com>
To: "Veerabomma, Naresh" <naresh.veerabo...@ihealthtechnologies.com>;
"'excel-macros@googlegroups.com'" <excel-macros@googlegroups.com>
Sent: Tuesday, July 23, 2013 2:59 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidated” sheet
________________________________
From: ravinder negi <ravi_colw...@yahoo.com>
To: "Veerabomma, Naresh" <naresh.veerabo...@ihealthtechnologies.com>;
"'excel-macros@googlegroups.com'" <excel-macros@googlegroups.com>
Sent: Tuesday, July 23, 2013 2:58 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidated” sheet
Hi Naresh earlier you mentioned that number of columns are same in all sheets
however rows are diff, so I have fixed the columns, its ok.. now I have made it
dynamic...please try and advise is it ok now.
________________________________
From: "Veerabomma, Naresh" <naresh.veerabo...@ihealthtechnologies.com>
To: "'excel-macros@googlegroups.com'" <excel-macros@googlegroups.com>
Cc: 'ravinder negi' <ravi_colw...@yahoo.com>
Sent: Tuesday, July 23, 2013 12:55 PM
Subject: RE: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidated” sheet
Hi Ravi,
It is not working dynamically….If columns are more in any sheet those values
are not copying to consolidated sheet. Can you please check and update it….
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ravinder negi
Sent: Tuesday, July 23, 2013 3:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidated” sheet
PFA
________________________________
From:Vijay Gande <vijaykumar.ga...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Monday, July 22, 2013 8:56 PM
Subject: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and
past in the “Consolidated” sheet
Hi there,
I'm amateur with excel macros and need help with the following task,
I've an excel workbook with 16 sheets, all the sheets have same # of columns
but different # of rows. My task is to copy the data from each of these 16
sheets and past in the consolidate sheet in the same workbook. The rows in the
sheets are dynamic means they change every month.
Please find the attached excel for the sample data.
I appreciate you help in advance.
Thanks,
Vijay
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
________________________________
DISCLAIMER: This e-mail and any attachments are intended only for the
individual or company to which it is addressed and may contain information
which is privileged, proprietary, confidential and prohibited from disclosure
or unauthorized use under applicable law. If you are not the intended recipient
of this e-mail, you are hereby notified that any use, dissemination, or copying
of this e-mail or the information contained in this e-mail is strictly
prohibited by the sender. If you have received this transmission in error,
please return the material received to the sender and delete all copies from
your system.
________________________________
Email Confidentiality Notice: The information contained in this transmission is
confidential, proprietary or privileged and may be subject to protection under
the law,
including the Health Insurance Portability and Accountability Act (HIPAA). The
message
is intended for the sole use of the individual or entity to whom it is
addressed. If you are
not the intended recipient, you are notified that any use, distribution or
copying of the
message is strictly prohibited and may subject you to criminal or civil
penalties. If you
received this transmission in error, please contact the sender immediately by
replying to
this email and delete the material from any computer.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.