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 <[email protected]>
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
<[email protected]> wrote:
------------------------------ --------------
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS
<[email protected] > wrote:
Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
To: [email protected]
Date: Wednesday, January 11, 2017, 1:17 AM
------------------------------ --------------
On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA
MACROS <[email protected] >
wrote:
Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address
formula
To: [email protected]
Date: Wednesday, January 11, 2017, 1:13 AM
------------------------------ --------------
On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA
MACROS <[email protected] >
wrote:
Subject: Re: $$Excel-Macros$$
Index+Match+Indirect+Address
formula
To: [email protected]
Date: Tuesday, January 10, 2017, 7:12 PM
------------------------------ --------------
On Tue, 1/10/17, Paul Schreiner <[email protected]>
wrote:
Subject: Re: $$Excel-Macros$$
Index+Match+Indirect+Address
formula
To: "[email protected] "
<[email protected] >
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 <[email protected]>
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 [email protected].
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 [email protected].
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 [email protected].
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 [email protected].
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 [email protected].
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 [email protected].
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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
