Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread amar takale
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 fiel

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread martinez.david533 via MS EXCEL AND VBA MACROS
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread mintaspriggs via MS EXCEL AND VBA MACROS
On Wed, 1/11/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:17 AM

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread silvers.r via MS EXCEL AND VBA MACROS
On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM ---

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Tue, 1/10/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You ha

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-10 Thread Paul Schreiner
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:

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread Paul Schreiner
Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different  heading/column combinations.then write to these column numbers.That way, I c

$$Excel-Macros$$ Re: Urgent helping hands are required

2017-01-10 Thread Pramod Kumar
Dear Friends, Please help generously. Your small help would be highly appreciated in my situation. Regards, Pramod On Friday, January 6, 2017 at 2:52:14 PM UTC, Pramod Kumar wrote: > > Dear Friends, > > Let me introduce myself - My name is Pramod Kumar. I am staying in the > Forest Gate, Lond

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Tue, 1/10/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 10:39 AM -

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread Devendra Sahay
Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for mu

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread cronincarmelita via MS EXCEL AND VBA MACROS
On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 10:29 AM

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-10 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Tue, 1/10/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 9:34 AM --