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

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

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

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

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 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

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

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

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

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

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$$ move sheets to a workbook

Sir, I am really very sorry for that, and you are really really kind person, I really really appreciate your efforts you have made and once again I'm sorry. thank you very much sir, you have done a very good job "may GOD bless you always" -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

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

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

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$$ move sheets to a workbook

Take a look at the macros in the attached file.Note: macros cannot be stored in .xlsx files. They must be in type .xlsm or .xlsb (which I prefer) Secondly, the use of terminology in the description of your requirement is important.In your requirement: "I want to transfer all the 31 workbooks to

Re: $$Excel-Macros$$ HOW TO CHANGE VBA TO COPY DATA IRRESPECTIVE OF WORKSHEET NAME

Does the current path have more than one zip file?more than one csv file? How do you determine which zip file (and csv file) you will process?(is it the latest file?) You can use the FileSystem object     Set fso = CreateObject("Scripting.FileSystemObject") to cycle through the folder, looking

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

Dear Friends, I am going through sleepless night's because of NO arrangement is made until now. - My owner has stopped hot water from last 4 days. - My owner has yesterday hidden the wireless router power cable. No internet connection at home since yesterday evening hours. - Lots of pressure by

Re: $$Excel-Macros$$ copy only yellow cells

This can be done fairly easily with VBA:Sub CopyCells()     Dim Rng As Range, nRow     '---     Sheets("Sheet1").Cells.ClearContents     nRow = 0     '---     For Each Rng In Sheets(1).UsedRange    

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.