Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread Vaibhav Joshi
Hi Bob Check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Dec 20, 2014 at 9:19 AM, bobengler wrote: > Could you change your code to get Sheet1 columns A-L and append Sheet2 > columns A-T all into Sheet3 if they match like in the test data

Re: $$Excel-Macros$$ cells.find

2014-12-19 Thread Ashish Kumar
Hi Ashakala, PFA Regards Ashish -- 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

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread bobengler
Could you change your code to get Sheet1 columns A-L and append Sheet2 columns A-T all into Sheet3 if they match like in the test data? The data I use is under a non-disclosure with my client so I can't really send it. Thanks, Bob From: Ashish Kumar To: Vaib

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread Ashish Kumar
Vaibhav Bhai, Superb..!! Regards Ashish -- 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 title

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread bobengler
It works great except My real Sheet1 has columns A-L and Sheet2 has columns A-T. I couldn't tell how to modify your code to get all the columns into Sheet3. Thanks, Bob From: Vaibhav Joshi To: "excel-macros@googlegroups.com" Sent: Thursday, December 18, 201

$$Excel-Macros$$ Very urgent need of Java Developer with JBoss & Camel experience.

2014-12-19 Thread Mazhar Khan
Hello, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for Java Developer with JBoss & Camel experience. position in *Boston, MA*. Please find below the job description for the same and revert back to me with your updated profile and contact details at the ea

Re: $$Excel-Macros$$ cells.find

2014-12-19 Thread Bé Trần Văn
You refer to File. 2014-12-19 23:32 GMT+07:00 : > > Hi Ashish, > > Yes, want to fetch a address of a cell containing particular word. > > > On Friday, December 19, 2014 9:00:43 PM UTC+5:30, Ashish Kumar wrote: >> >> Hi ashakala, >> >> you want to find specific word in sheet. >> >> >> >> On 19 Dece

Re: $$Excel-Macros$$ cells.find

2014-12-19 Thread ashakala16
Hi Ashish, Yes, want to fetch a address of a cell containing particular word. On Friday, December 19, 2014 9:00:43 PM UTC+5:30, Ashish Kumar wrote: > > Hi ashakala, > > you want to find specific word in sheet. > > > > On 19 December 2014 at 20:40, > wrote: >> >> >> Can anyone help me with below

Re: $$Excel-Macros$$ cells.find

2014-12-19 Thread Ashish Kumar
Hi ashakala, you want to find specific word in sheet. On 19 December 2014 at 20:40, wrote: > > > Can anyone help me with below code, > > Dim range1 As Range > > range1 = Cells.Find(what:="range") > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:I

$$Excel-Macros$$ cells.find

2014-12-19 Thread ashakala16
Can anyone help me with below code, Dim range1 As Range range1 = Cells.Find(what:="range") -- 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

$$Excel-Macros$$ Very urgent need of .Net Lead Developer with strong MVC Architecture experience.

2014-12-19 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *.Net Lead Developer* position in *Atlanta, GA*. Please find below the job description for the same and revert back to me with your Consultant updated profile and contact details at the ear

Re: $$Excel-Macros$$ Add control on button click

2014-12-19 Thread Rupesh Patil
Hello Vaibhav, 2nd approach full fill my requirement. 1) Add text boxes vertically. 2) resize form that is fine. Vaibhav very very thank you for looking into my requirement. On Fri, Dec 19, 2014 at 5:31 PM, Vaibhav Joshi wrote: > > Hi > > Rupesh, there is 2 methids thru which this can be achi

Re: $$Excel-Macros$$ Add control on button click

2014-12-19 Thread Vaibhav Joshi
Hi Rupesh, there is 2 methids thru which this can be achieved!! 1st comparatively easy, creating pre-defined no. of extra text box & hiding them, on clicking add unhide them & resize the form. 2ns Add text boxes on every click, this requires to identify place for new text box & resize of forms!

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2014-12-19 Thread Ashu k
Dear Mandeep Sir, It's not working. Thanks Ashu Kenith. On Thu, Dec 18, 2014 at 8:00 PM, Ashu k wrote: > > Dear Mandeep Sir, > > The code which is provided by you is not working properly. It's giving NA# > in sheet 2. > > Formula is working fine for me which is provided by Ashish Sir & Vaibhav

Re: $$Excel-Macros$$ Add control on button click

2014-12-19 Thread Rupesh Patil
Hello Vaibhav, I want add text boxes on button click on userfrom(Runtime). please find example sheet in attachment. On Fri, Dec 19, 2014 at 12:28 PM, Vaibhav Joshi wrote: > > Hi > > can you elaborate what exactly you want with example.. > > Cheers!! > > + > *I did not do this for you. God is