$$Excel-Macros$$ Java Developer with Angular JS @ Bothell,WA
Hi Hope you are doing great. Please go through the below Job Description, if you are comfortable please send me your updated resume along with contact details to *govind_ramanu...@visionisys.com* *Role : Java Front End Developer* *Location : Bothell, WA* *Duration : 12 months* Functional requirement understanding of Front End development*( Need Angular-Js Profile with HTML, Not UI Developer)* Understand the current architecture of the customer business line Discussing technical solutions with customer technical team and suggesting innovative ideas for solutions Maintaining a high awareness of industry issues and trends for UI development work, particularly in regard to web accessibility, usability, and emerging technologies Interaction with other teams (QA, Business, Technical Architect) *Required Skills:* Java JQuery Jscript HTML JSP *Desired Skills:* Ajax, JSON JS Framework, JSTL HTML5, CSS3 Code optimization Cross Browser issues, Multiple devices Soft Skills -- 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+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, karleenbiggs via MS EXCEL AND VBA MACROSwrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:47 AM On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:05 AM On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " Date: Wednesday, January 11, 2017, 3:56 PM 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 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
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Fri, 1/13/17, spainy via MS EXCEL AND VBA MACROSwrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 11:42 AM On Fri, 1/13/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:47 AM On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 9:05 AM On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:48 AM On Fri, 1/13/17, amar takale wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 6:20 AM Dear Paul Sir Good Morning Sorry for Late reply. Actually Index match is as per my thinking formula it not fix for this situation , you can also give another formula or option. I am thinking index match formula match criteria field like year & net sales & address find sheet name. So I ask for that. which I attached index formula file for only your reference sheet where index match+indirect formula extract data but internal sheet only & I want extract it external workbooks in folder. Step 1) Extract All sheet from software in folder & next time only overwrite on it if any updation. 2) Create One output sheet in folder where more than 100 sheets data extract fieldwise,yearwise & worksheets wise through formula OR VBA. 3) Suggest formula or VBA Regards Amar On Thu, Jan 12, 2017 at 2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS wrote: -- -- On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Thursday, January 12, 2017, 3:26 AM -- -- On Wed, 1/11/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com " Date: Wednesday, January 11, 2017, 3:56 PM 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 wrote: Dear Paul Good Morning. Exact explanation by
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Fri, 1/13/17, storeythomas725 via MS EXCEL AND VBA MACROSwrote: 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 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 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 Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: 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/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 can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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 4:07 AM, Devendra Sahay wrote: 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 multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: 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 all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: 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-- --- “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 Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: 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-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 Workbook2.xlsx file? Paul-- --- “Do all the good
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Fri, 1/13/17, Paul Schreinerwrote: 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 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 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 Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: 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/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 can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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 4:07 AM, Devendra Sahay wrote: 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 multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: 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 all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: 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-- --- “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 Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: 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-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 Workbook2.xlsx 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 Saturday, January 7, 2017 10:42 PM, Devendra Sahay 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
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 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 Friday, January 13, 2017 2:29 AM, Devendra Sahaywrote: 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/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 can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. 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 4:07 AM, Devendra Sahay wrote: 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 multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: 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 all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: 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-- --- “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 Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: 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-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 Workbook2.xlsx 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 Saturday, January 7, 2017 10:42 PM, Devendra Sahay 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 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 be really appreciated. Scenario- I have a dump file with the record in the columns & rows with headers. I have a another file in which I want to extract the details from the dump file in the respect of header & the value. The value (It could be number or the text), of which details I want to pull from dump file,