Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, spainy via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 11:42 AM On Fri, 1/13/17, karleenbiggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:47 AM On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:05 AM On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale <amartak...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote:
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, karleenbiggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:47 AM On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:05 AM On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale <amartak...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:05 AM On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale <amartak...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale <amartak...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 A
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, amar takale <amartak...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM - - -- On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM -- -- On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > > > On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula > To: excel-macros@googlegroups.com > Date: Thursday, January 12, 2017, 3:26 AM > > > > On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> > wrote: > > Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address > formula > To: "excel-macros@googlegroups.com" > <excel-macros@googlegroups.com> > Date: Wednesday, January 11, 2017, 3:56 PM > > OK. > It > sounds like you're saying that you have some > reporting software that generates a report > file.But > evidently I don't understand what it is you're > trying to do. > Can > you describe it step-by-step with examples?What > does the file generated by your software look > like?what do you do with it? > I have the two files you sent originally, but I > don't see what information is common between the two > files,so I don't know how you get from the > "Index-Match" file to the "output" > file. Paul- > “Do all the good you > can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > - > > > > On Tuesday, January 10, 2017 11:48 > PM, amar takale <amartak...@gmail.com> > wrote: > > >Dear Paul > > Good Morning. > > Exact explanation by you > regarding my issue.Required field (like net sales,Share > capital,cash) extract after match year & show in > output > sheet. > > And also one > thing that there are no need to open 100 sheet bcos all > sheet extract from our software with same format (only > field > up & down if any issue otherwise same format).Once > output sheet prepared with formula OR VBA in folder then > next time all sheet extract from software & overwrite > on > it in same folder so data update 100 sheet automatically > from software.No required to check updation of each > sheet. > > Pls suggest > formula OR VBA.Send example sheet. > > Other two members group try to > solution my issue but I cant understand their language. > > Regards > Amar > > > On Wed, Jan 11, 2017 at > 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS > <excel-macros@googlegroups.com> > wrote: > > > -- -- > > On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS > <excel-macros@googlegroups.com > > > wrote: > > > > Subject: Re: $$Excel-Macros$$ > Index+Match+Indirect+Address formula > >To: excel-macros@googlegroups.com > >Date: Wednesday, January 11, 2017, 1:17 AM > > > > > >-- -- > >On Wed, 1/11/17, julienneschindler via MS EXCEL AND > VBA > >MACROS <excel-macros@googlegroups.com > > > >wrote: > > > > Subject: Re: $$Excel-Macros$$ > Index+Match+Indirect+Address > >formula > > To: excel-macros@googlegroups.com > > Date: Wednesday, January 11, 2017, 1:13 AM > > > > > > -- -- > > On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND > VBA > > MACROS <excel-macros@googlegroups.com > > > > wrote: > > > > Subject: Re: $$Excel-
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM -- -- On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM -- -- On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM -- -- On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Wed, 1/11/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, January 11, 2017, 3:56 PM OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM -- -- On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM -- -- On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM -- -- On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
OK. It sounds like you're saying that you have some reporting software that generates a report file.But evidently I don't understand what it is you're trying to do. Can you describe it step-by-step with examples?What does the file generated by your software look like?what do you do with it? I have the two files you sent originally, but I don't see what information is common between the two files,so I don't know how you get from the "Index-Match" file to the "output" file. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 11:48 PM, amar takale <amartak...@gmail.com> wrote: Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: -- -- On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM -- -- On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM -- -- On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM -- -- On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " <excel-macros@googlegroups.com > Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 2:34 AM, amar takale <amartak...@gmail.com> wrote: Dear Friends There are more than 100 Excel Sheet
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
Dear Paul Good Morning. Exact explanation by you regarding my issue.Required field (like net sales,Share capital,cash) extract after match year & show in output sheet. And also one thing that there are no need to open 100 sheet bcos all sheet extract from our software with same format (only field up & down if any issue otherwise same format).Once output sheet prepared with formula OR VBA in folder then next time all sheet extract from software & overwrite on it in same folder so data update 100 sheet automatically from software.No required to check updation of each sheet. Pls suggest formula OR VBA.Send example sheet. Other two members group try to solution my issue but I cant understand their language. Regards Amar On Wed, Jan 11, 2017 at 9:04 AM, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: > > > On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula > To: excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 1:17 AM > > > > On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA > MACROS <excel-macros@googlegroups.com> > wrote: > > Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address > formula > To: excel-macros@googlegroups.com > Date: Wednesday, January 11, 2017, 1:13 AM > > > > On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA > MACROS <excel-macros@googlegroups.com> > wrote: > >Subject: Re: $$Excel-Macros$$ > Index+Match+Indirect+Address > formula >To: excel-macros@googlegroups.com >Date: Tuesday, January 10, 2017, 7:12 PM > > >------------ > On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> >wrote: > > Subject: Re: $$Excel-Macros$$ > Index+Match+Indirect+Address >formula > To: "excel-macros@googlegroups.com" ><excel-macros@googlegroups.com> > Date: Tuesday, January 10, 2017, 3:59 PM > > OK, > I think I've worked through your > requirements...You > have a folder with more than 100 workBOOKS.Each > workbook is >for a specific company (AAB, > Infy, TATA, etc.)Each workbook has three workSHEETS > (often >called "Sheets" and are > displayed as "tabs" across the bottom of the > Excel window) for:Profit > & loss A/CBalance > SheetCash > Flow > Your goal is to have a workbook with a Summary > sheet thatshows specific data like:Net > salesNet > ProfitShare > CapitalCashfrom each of the 100+ >workbooksYour use of the =INDIRECT() >function is nicely > done.Many users have difficulty with the concept of > using cell values to "indirectly" refer to other > worksheets. > However, in this case, I wouldn't recommend > it. > As you no doubt are aware, you cannot use this to > refer to a worksheet that doesn't exist.in the same > way, >you CAN use this to refer to a > worksheet in another workbook, but the workbook must > be > OPEN.That means that if your summary > sheet refers to sheets in 100 workbooks, all of the > workbooks would need to be open at the same > time!Which >would require quite a bit in system > resources. > this kind of thing can be easily done > with VBA. > I can help with this if you'd like.I've done it > before with >nearly 300 > workbooks. > > Paul- > “Do > all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > - > > > > On Tuesday, January 10, 2017 2:34 AM, > amar takale <amartak...@gmail.com> >wrote: > > > > > Dear Friends > > > > There are more than 100 > Excel Sheets (Company Name like AAB, > Infy, TATA) in folder. Each Sheet there are 3 tab > (Profit > & loss A/C, > Balalnce Sheet, Cash Flow from 10 years).I Required >Separate > one Output Excel > sheet where I extract specific data (like Net sales, > Net > Profit, Share Capital, > Cash) from Each sheet (like ABB,TATA) from each
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 2:34 AM, amar takale <amartak...@gmail.com> wrote: Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- 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 Prob
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 2:34 AM, amar takale <amartak...@gmail.com> wrote: Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- 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 Prob
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 2:34 AM, amar takale <amartak...@gmail.com> wrote: Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- 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 https://groups.google.com/group/excel-macros. For more optio
$$Excel-Macros$$ Index+Match+Indirect+Address formula
Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Output.xls Description: MS-Excel spreadsheet Index-Match-Indirect-REIT-Data-After.xlsx Description: MS-Excel 2007 spreadsheet