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

Paul, would you please look into this. On Jan 16, 2017 9:31 AM, "Devendra Sahay" wrote: > Hey Paul, > > > Would you please look into this. > > > On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi Paul, >> >> Yes both

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

On Tue, 1/17/17, georgemartin812 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Tuesday, January 17, 2

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

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

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

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

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

On Mon, 1/16/17, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 20

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

On Mon, 1/16/17, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 3

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

On Mon, 1/16/17, Devendra Sahay <devendrasahanypt...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 16, 2017, 6:01 AM Hey Paul, Wou

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

Hey Paul, Would you please look into this. On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Paul, > > Yes both columns have only one column, I just wanted to check howmany > values ar availble in the dump using vlookup. > > I just changed the

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

On Sun, 1/15/17, keisha.fry via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 1

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

On Sun, 1/15/17, mintaspriggs via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017,

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

On Sun, 1/15/17, libertystringer via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 20

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

On Sun, 1/15/17, julienneschindler via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2

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

On Sun, 1/15/17, martinez.david533 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2

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

On Sun, 1/15/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 4

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

On Sat, 1/14/17, Devendra Sahay <devendrasahanypt...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Saturday, January 14, 2017, 7:37 AM Hi Paul, Ye

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

On Fri, 1/13/17, storeythomas725 via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Friday, January 13, 2017

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

On Fri, 1/13/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Friday, Jan

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

I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify?  Paul- “Do all the good you can, By all the means

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

Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner

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

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

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

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

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

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

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

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

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

On Mon, 1/9/17, Devendra Sahay <devendrasahanypt...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 9, 2017, 6:23 PM Paul, I mean to say

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

On Mon, 1/9/17, silvers.r via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 9, 2017, 11

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

On Mon, 1/9/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Monday, Ja

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

On Mon, 1/9/17, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Monday, Ja

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

Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. 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

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

On Mon, 1/9/17, Devendra Sahay <devendrasahanypt...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 9, 2017, 6:23 PM Paul, I mean to say

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

Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: > First occurrence of... what? > First occurrence of the Order ID? > customer ID? > > Is the data already sorted in the order by which you want to determine > "first

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

First occurrence of... what?First occurrence of the  Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all

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

Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For

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

I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the

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

Paul & Mandeep, Would you please look into this. On Mon, Jan 9, 2017 at 4:16 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Guys waiting for your reply. > > On Sun, Jan 8, 2017 at 9:12 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi Team, >> >> Sorry for

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

Guys waiting for your reply. On Sun, Jan 8, 2017 at 9:12 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Team, > > Sorry for posting such a long query on the forum, but am working on few > reports in which I have to write the Index match formula multiple times on > daily basis.

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

Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis. So am thinking to write a macro for this but as I am new to VBA, am not able to do so. If you guys can help me out here, would