Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

I made a small change to the code to get the last row. You can check this now: *Sub Macro3() ' ' Macro3 Macro '* *' * *Windows("report(2).xls").Activate **Last_row = Range("A" & Rows.Count).End(xlUp).Row* *Rows("4:" & last_row).Select 'Range("B4").Activate Selection.Copy Windows("p

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

You are welcome Karthik!! On Fri, Dec 25, 2009 at 10:24 AM, grlinks-karthik wrote: > Thank you praveen, > > > > > On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar > wrote: > >> Hi Grlinks, >> >> Attach this macro for Report(2) sheet and run the macro3. You should be >> able to see the desire

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Dear Praveen I am getting runtime error "1004", (applicatinon difined or object defined error), and also you specified row no in the macro, but i donot know how many rows will be in report(2) sheet, sample purpose i have mention 15rows, actuallay it will be 50 or 100 rows kindly help me On Thu

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Thank you praveen, On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar wrote: > Hi Grlinks, > > Attach this macro for Report(2) sheet and run the macro3. You should be > able to see the desired result. > Make sure you open both the files before running the macro3. > Let me know in case you hav

$$Excel-Macros$$ Fwd: VBA \ Access profiles

Dear Group, The below mail is on behalf of Karthik Seshadri. Its a good opportunity for bangalore job seekers. Cheers. Merry Christmas :) Best regards, Ayush Jain Group Owner Hi , I am Karthik and I work for a MNC in bangalore I am looking for profiles of people who are good in VBA and MS Acc

RE: $$Excel-Macros$$ need urgent help

Hi Sachin, Have a look at the attached to see if it does what you need. Regards, and Merry Christmas. Dave. Date: Thu, 24 Dec 2009 17:40:36 +0530 Subject: $$Excel-Macros$$ need urgent help From: sachinmbafina...@gmail.com To: excel-macros@googlegroups.com Dear Friend, Pls find attached sheet w

Re: $$Excel-Macros$$ Find specified word is contained in a text string

You are Welcome Mahesh!! On Thu, Dec 24, 2009 at 8:27 PM, mahesh parab wrote: > Hi Praveen > > Thank you so much ! it's amazing , i appreciate your knowledge & help. > > On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar > wrote: > >> Hi Mahesh, >> >> Use this function along with the Exactwo

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Hi Grlinks, Attach this macro for Report(2) sheet and run the macro3. You should be able to see the desired result. Make sure you open both the files before running the macro3. Let me know in case you have any difficulties. *Sub Macro3() ' ' Macro3 Macro '* *' Windows("report(2).xls").Activate

Re: $$Excel-Macros$$ Find specified word is contained in a text string

Hi Praveen Thank you so much ! it's amazing , i appreciate your knowledge & help. On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar wrote: > Hi Mahesh, > > Use this function along with the Exactwordinstring function. > > Function checkthis(Text As String, rng As Range) > For Each entry In rng

Re: $$Excel-Macros$$ drop down menu

Hello Muneer, Check the attachment,,, is this what you want .. On Thu, Dec 24, 2009 at 7:40 PM, Muneer Ansari wrote: > > > I have maked two drop down menu on excel named "Reason-main" and "Reason > sub", there are 5 reasons in "Reason-main" and 50 resons in "reason-sub", > My problem is that w

$$Excel-Macros$$ drop down menu

I have maked two drop down menu on excel named "Reason-main" and "Reason sub", there are 5 reasons in "Reason-main" and 50 resons in "reason-sub", My problem is that when i choose a reason from reason-main then reason-sub should show only those reason which are belong to "reason-main" ie

Re: $$Excel-Macros$$ max_units_on_a_day

Dear Mr. Singh, I doubt if you have gone through the solution provided by me thoroughly. Watch out for Option 2 and the next column and you'll get the exact answer as desired. Dear Praveen, Let me know if you are have any query(ies). "Merry Christmas" to all...!! Best Regards, DILipandey -- D

Re: $$Excel-Macros$$ SUMIF realted

You are welcome..!! "Merry Christmas" Thanks & Best Regards, DILipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/21/09, chetu wrote: > > Wow! that was a great take away Dilip Sir, Thank you very

Re: $$Excel-Macros$$ Help required on cell movement

You are welcome..!! "Merry Christmas" Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/24/09, Sachin Shukla wrote: > > Dear Dilip, > > Thanks a lot. > > > Sachin Shukla > > > On Thu, Dec 2

Re: $$Excel-Macros$$ Re: Cell Movement

Dear Dilip, I am not get your query. Thanks Sachin On Thu, Dec 24, 2009 at 3:28 PM, Dilip Pandey wrote: > Dear Sachin, > > "merry christmas" > Just answerd this query. Let me know if you do not find the same. Thanks. > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA >

$$Excel-Macros$$ Re: Cell Movement

Dear Sachin, "merry christmas" Just answerd this query. Let me know if you do not find the same. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/24/09, Sachin Shukla wrote: > > D

Re: $$Excel-Macros$$ Help required on cell movement

Dear Sachin, "merry christmas" Attached file has been solved / customised as per your needs. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/24/09, Sachin Shukla wrote: > > Dear A

Re: $$Excel-Macros$$ if statements with several matching values.

Thanks Praveen, I suggest you to take the code to a VB environment and test it. But the approach is good. Dear Mike, the things which matters most is whether our problem is solved or not. If you need the answer in VBA, then you would have mentioned specifically a "VBA Solution Only". I generall

Re: $$Excel-Macros$$ Help on macros - Mail sent from Excel

Hi, I meant it this way .HTMLBody = strbody & vbNewLine & RangetoHTML(rng) & Signature On Thu, Dec 24, 2009 at 12:27 PM, Vinod N wrote: > Hi Praveen, > > Do you mean .htmlbody should read as below: > > .HTMLBody = Please clarify the following:" & vbNewLine & RangetoHTML(rng) & > Signature > >

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Hi I have Two sheets Name called Report2, and paybill, Paybill sheet contain the format and data to be copied from Report2, when i click the button or macro Report2 sheet data to be copied and paste in the Paybill sheet as required format problem both the sheet not in same workbook , both are i

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Hi thank you for your reply, let me explain my requirement , On Wed, Dec 23, 2009 at 11:30 PM, kvc praveen kumar wrote: > Hi Karthik, > > What is the data that you want to copy and into which shet you want to > copy. > > On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik wrote: > >> Hi >> any c

$$Excel-Macros$$ Help required on cell movement

Dear All, Please help me on attached file. Thanks in advance Sachin Shukla -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.c