Re: $$Excel-Macros$$ Excel Exctact Data

2016-02-02 Thread Abhishek Jain
Does this help? On Wed, Feb 3, 2016 at 11:54 AM, Vijayendra Rao wrote: > Dear Expert, > > > > I have time sheet which is received from my team and I tried to extract > data in to separate columns. I have tried with combination of formula of > “left, mid, right, find” but still it is not coming

Re: $$Excel-Macros$$ compare columns through for loop

2016-02-02 Thread 'karunanithi ramaswamy' via MS EXCEL AND VBA MACROS
Hi,I enclose which may solve ur request. From: Kat To: MS EXCEL AND VBA MACROS Sent: Wednesday, February 3, 2016 6:28 AM Subject: $$Excel-Macros$$ compare columns through for loop Hi all, I would like to compare columns in two workbooks. If data from column D in fortest1.xlsx a

Re: $$Excel-Macros$$ macro for custom views

2016-02-02 Thread GENIUS
Oh that's really great thank you very much for your help > > -- 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

$$Excel-Macros$$ Excel Exctact Data

2016-02-02 Thread Vijayendra Rao
Dear Expert, I have time sheet which is received from my team and I tried to extract data in to separate columns. I have tried with combination of formula of “left, mid, right, find” but still it is not coming properly. Request you to help me to find out the solution. Attached is the excel file.

$$Excel-Macros$$ Defining Name Ranges in Excel for different selection region using VBA/Macro

2016-02-02 Thread Sandeep Kumar Baranwal
Hi Please note that I do not want to manually define name range for selected columns. Could anyone help me with this. The number of columns and rows are fixed for each name range separated by a constant width. For example: a name range is to be defined for selection $A$1:$B$10 Another name range i

$$Excel-Macros$$ compare columns through for loop

2016-02-02 Thread Kat
Hi all, I would like to compare columns in two workbooks. If data from column D in fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If they are not matched, then data from column A to C in fortest1.xlsx needs to be copied and pasted to column C to E in tested.xlsm. Please

$$Excel-Macros$$ Client in Atlanta, GA need Lawson Consultant

2016-02-02 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title:** Lawson Consultant* *Duration: **3+ months* *Location: **Atlanta, GA* *JD:-* The HR Technology Manager provides hands-on management of the day-to-day support for APS’s Infor Global HR system, as

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2016-02-02 Thread Samuellificationable
Hi, Thanks so much for the code but for me even though I select the folder (which currently contains two filled in Word forms), it only transfers the headings and "Please enter text" for each field even though text has been filled in. Could this be because I used plain text content controls?

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2016-02-02 Thread Samuellificationable
Hi, I know I'm a bit late to this so might not get answer but your code is exactly what I need to do but I get a runtime error on the line Dim appWord As Word.Application with the error "User-defined type not defined", do you have any idea why? Thanks so much for the code. On Wednesday, Octobe

$$Excel-Macros$$ URGENT NEED SAP Basis -HOUSTON, TX---SEND 10+ YEARS RESUME ONLY

2016-02-02 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *TITLE : SAP BASIS* *LOCATION : HOUSTON, TX* JD:- ü*10+ years of Core SAP Basis experience.* üStrong administration skills on both ABAP and JAVA stacks. üSystem installation/ builds, migratio

Re: $$Excel-Macros$$ macro for custom views

2016-02-02 Thread Paul Schreiner
Do you mean: Application.Dialogs(xlDialogCustomViews).Show ? 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 We

Re: $$Excel-Macros$$ Change in existing macro.

2016-02-02 Thread Paul Schreiner
OOps..I copied one of my "quick and dirty" macrosand change the variable names to be somewhat more intuitive. But I guess I didn't change them all! sorry about that. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all th

Re: $$Excel-Macros$$ Sampling - Please check

2016-02-02 Thread SG
Hi Paul, Added Column "D" as unique id & what needed as result is in "Result" sheet. It would require per month-per slot-per name >> 3 samples. VBA Macro looks a great idea to work with this. PFA for your reference. My apologies & promise no other modification would be required after this. O