Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Yes, I put the path of file and this was not worked so I put the path of folder also. But it is not working. I want various sheets in single workbook. Sagar On Mon, Oct 28, 2013 at 5:26 PM, Ravinder wrote: > Did you put path in range “b2” of first sheet.? > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar > *Sent:* Monday, October 28, 2013 5:20 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from > various workbook to specific workbook > > ** ** > > ** ** > > Dear Ravindra, > > ** ** > > Run time error 9 is showing after running macro. Kindly send me the macro > for copy sheets from various workbooks to single workbook. > > ** ** > > Thanks , > > ** ** > > Sagar > > On Mon, Oct 28, 2013 at 2:26 PM, Ravinder > wrote: > > Try this one… > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar > *Sent:* Monday, October 28, 2013 1:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from > various workbook to specific workbook > > > > Dear Rupesh, > > > > I want to copy worksheett from various workbooks to single workbook. > > > > Thanks & Regards, > > > > Sagar > > > > On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil > wrote: > > hi Sagar*.* > > > > *First all of i want's tell, I am new on this forum so excel, so may be > this link will help you or you want through it, * > > http://www.wikihow.com/Consolidate-in-Excel > > > > *thanks * > > > > On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < > sagarkasangottu...@gmail.com> wrote: > > Dear Experts, > > > > I have 100 worksbooks which contains worksheet (i.e. Profitability) so I > want to consolidate all the worksheets in one workbook. This worksheet data > is linked from other worksheets so I want that data in as it is in > consolidated workbook. > > > > Kindly help me in this VBA. > > > > Thanks & Regards, > > > > Sagar > > > > -- > 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. > > > > > > > > -- > > Thanks and Regards, Rp. > > -- > 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 los
RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Did you put path in range "b2" of first sheet.? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 5:20 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook Dear Ravindra, Run time error 9 is showing after running macro. Kindly send me the macro for copy sheets from various workbooks to single workbook. Thanks , Sagar On Mon, Oct 28, 2013 at 2:26 PM, Ravinder wrote: Try this one. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook Dear Rupesh, I want to copy worksheett from various workbooks to single workbook. Thanks & Regards, Sagar On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil wrote: hi Sagar. First all of i want's tell, I am new on this forum so excel, so may be this link will help you or you want through it, http://www.wikihow.com/Consolidate-in-Excel thanks On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar wrote: Dear Experts, I have 100 worksbooks which contains worksheet (i.e. Profitability) so I want to consolidate all the worksheets in one workbook. This worksheet data is linked from other worksheets so I want that data in as it is in consolidated workbook. Kindly help me in this VBA. Thanks & Regards, Sagar -- 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 <mailto:excel-macros%2bunsubscr...@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. -- Thanks and Regards, Rp. -- 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 <mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Dear Ravindra, Run time error 9 is showing after running macro. Kindly send me the macro for copy sheets from various workbooks to single workbook. Thanks , Sagar On Mon, Oct 28, 2013 at 2:26 PM, Ravinder wrote: > Try this one… > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar > *Sent:* Monday, October 28, 2013 1:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from > various workbook to specific workbook > > ** ** > > Dear Rupesh, > > > > I want to copy worksheett from various workbooks to single workbook. > > ** ** > > Thanks & Regards, > > ** ** > > Sagar > > ** ** > > On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil > wrote: > > hi Sagar*.* > > ** ** > > *First all of i want's tell, I am new on this forum so excel, so may be > this link will help you or you want through it, * > > http://www.wikihow.com/Consolidate-in-Excel > > ** ** > > *thanks * > > ** ** > > On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < > sagarkasangottu...@gmail.com> wrote: > > Dear Experts, > > ** ** > > I have 100 worksbooks which contains worksheet (i.e. Profitability) so I > want to consolidate all the worksheets in one workbook. This worksheet data > is linked from other worksheets so I want that data in as it is in > consolidated workbook. > > ** ** > > Kindly help me in this VBA. > > ** ** > > Thanks & Regards, > > ** ** > > Sagar > > ** ** > > -- > 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. > > > > > > ** ** > > -- > > Thanks and Regards, Rp. > > -- > 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. Po
RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Try this one. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook Dear Rupesh, I want to copy worksheett from various workbooks to single workbook. Thanks & Regards, Sagar On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil wrote: hi Sagar. First all of i want's tell, I am new on this forum so excel, so may be this link will help you or you want through it, http://www.wikihow.com/Consolidate-in-Excel thanks On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar wrote: Dear Experts, I have 100 worksbooks which contains worksheet (i.e. Profitability) so I want to consolidate all the worksheets in one workbook. This worksheet data is linked from other worksheets so I want that data in as it is in consolidated workbook. Kindly help me in this VBA. Thanks & Regards, Sagar -- 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 <mailto:excel-macros%2bunsubscr...@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. -- Thanks and Regards, Rp. -- 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 <mailto:excel-macros%2bunsubscr...@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 optio
Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Dear Rupesh, I want to copy worksheett from various workbooks to single workbook. Thanks & Regards, Sagar On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil wrote: > hi Sagar*.* > > *First** all of i want's tell, I am new on this forum so excel, so may > be this link will help you or you want through it, * > http://www.wikihow.com/Consolidate-in-Excel* > * > * > * > *thanks * > > > On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < > sagarkasangottu...@gmail.com> wrote: > >> Dear Experts, >> >> I have 100 worksbooks which contains worksheet (i.e. Profitability) so I >> want to consolidate all the worksheets in one workbook. This worksheet data >> is linked from other worksheets so I want that data in as it is in >> consolidated workbook. >> >> Kindly help me in this VBA. >> >> Thanks & Regards, >> >> Sagar >> >> -- >> 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. >> > > > > -- > Thanks and Regards, Rp. > > -- > 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.
Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
hi Sagar*.* *First** all of i want's tell, I am new on this forum so excel, so may be this link will help you or you want through it, * http://www.wikihow.com/Consolidate-in-Excel* * * * *thanks * On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < sagarkasangottu...@gmail.com> wrote: > Dear Experts, > > I have 100 worksbooks which contains worksheet (i.e. Profitability) so I > want to consolidate all the worksheets in one workbook. This worksheet data > is linked from other worksheets so I want that data in as it is in > consolidated workbook. > > Kindly help me in this VBA. > > Thanks & Regards, > > Sagar > > -- > 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. > -- Thanks and Regards, Rp. -- 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.
$$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook
Dear Experts, I have 100 worksbooks which contains worksheet (i.e. Profitability) so I want to consolidate all the worksheets in one workbook. This worksheet data is linked from other worksheets so I want that data in as it is in consolidated workbook. Kindly help me in this VBA. Thanks & Regards, Sagar -- 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.
