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-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+ > > workbooks----------------Your 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+unsubscribe@ > 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. > > > > > > > > > > > > > > -- > > > > 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+unsubscribe@ > 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. > > DESFasURAREA EVENIMENTELOR DE LA 23 AUGUST > 1944. > > > > -- > > 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+unsubscribe@ > 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. > > Reintors dupa vizitele din China si Coreea de > Nord > > Nicolae Ceausescu lanseaza .Tezele din aprilie > care > > semnificau un control absolut asupra libertatii de > > creatie.197115 ian. - Inaugurarea barajului de la > Assuan > > pe > > Nil. > > > > -- > > 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+unsubscribe@ > 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.ratie > > priceperii si personalitatii oneste si integre a > > regelui institutia monarhica a stiut sa lupte > eficient > > pentru mentinerea si functionarea normala a > sistemului > > politic si s-a impus unor oameni politici de > prestigiu. > > Tendintele de autoritarism manifestate uneori de rege > nu au > > putut nega cadrul parlamentar si regimul democratic > din tara > > noastra. Desi a sustinut intotdeauna lupta nationala > a > > romanilor de peste munti Carol nu a putut lua > pozitie > > mereu favorabila in mod deschis in > problema > > nationala ci doar sa se alinieze pozitiei > guvernului. > > De asemenea el a patronat vasta opera de > modernizare a > > statului roman pornit pe drumul deplinei unitati > nationale. > > > > -- > > 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+unsubscribe@ > 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.resterea numarului locuitorilor oraselor reda mai > convingator procesul de urbanizare. Fata de procentul > asezarilor neagricole din Moldova 1 > 72% unaoara indicele concentrarii > populatiei in orasele si targurile Principatului respectiv > este superior 9 11% in 1803 .' > > > > -- > > 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+unsubscribe@ > 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. > > > > > > > -- > > 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. > > > > > > > -- > > 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. > rancisco8 21 febr > - inceputul unei puternice > rascoale taranesti in nordul Moldovei > febr - Miscari taranesti in judetele > din Moldova Apogeul rascoalei > in Moldova 6 19 mart -9 22 mart > > -- > 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.untenia zvonul ca guvernul a decis > improprietarirea taranilor dar marii > > -- > 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. > -- 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.
