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 columns have only one column, I
On Tue, 1/17/17, georgemartin812 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 17, 2017, 4:00 AM
On Tue, 1/17/17, mintaspriggs 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 17, 2017, 1:05 AM
On Tue, 1/17/17, mintaspriggs 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 17, 2017, 1:05 AM
On Mon, 1/16/17, martinez.david533 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: Monday, January 16, 2017, 10:11 PM
On Mon, 1/16/17, mintaspriggs 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: Monday, January 16, 2017, 3:18 PM
On Mon, 1/16/17, Devendra Sahay 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,
Would you please look into this.
On
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 column
On Sun, 1/15/17, keisha.fry 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: Sunday, January 15, 2017, 1:03 PM
On Sun, 1/15/17, mintaspriggs 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: Sunday, January 15, 2017, 10:49 AM
On Sun, 1/15/17, libertystringer 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: Sunday, January 15, 2017, 10:03 AM
On Sun, 1/15/17, julienneschindler 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: Sunday, January 15, 2017, 6:21 AM
On Sun, 1/15/17, martinez.david533 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: Sunday, January 15, 2017, 4:39 AM
On Sun, 1/15/17, silvers.r 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: Sunday, January 15, 2017, 4:25 AM
On Sat, 1/14/17, Devendra Sahay 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,
Yes both columns have only one column, I
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 column referrence in the code but its not running
properly.
Thanks,
Devendra
On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner
wrote:
> I'm sorry.
> I'
On Fri, 1/13/17, storeythomas725 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: Friday, January 13, 2017, 2:49 PM
On Fri, 1/13/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
To: "excel-macros@googlegroups.com"
Date: Friday, January 13, 2017, 2:27 PM
I'm
sorry.I'm
not sure what
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 y
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
wrote:
> Yes, Excel/V
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
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
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
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
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
On Mon, 1/9/17, Devendra Sahay 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 first
occurrence of the order id
On Mon, 1/9/17, silvers.r 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: Monday, January 9, 2017, 11:01 PM
On Mon, 1/9/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
To: "excel-macros@googlegroups.com"
Date: Monday, January 9, 2017, 7:48 PM
Take
a look at the macros attached.See
i
On Mon, 1/9/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
To: "excel-macros@googlegroups.com"
Date: Monday, January 9, 2017, 7:48 PM
Take
a look at the macros attached.See
i
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 al
On Mon, 1/9/17, Devendra Sahay 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 first
occurrence of the order id
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 occurrence"?
>
>
> *Paul*
>
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 t
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 instance, Order ID #CA-2014-AB10
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
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 posting
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. So
37 matches
Mail list logo