RE: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-14 Thread Rajan_Verma
oglegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prajakt Pande Sent: 14 May 2012 12:32 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt Dear Rakesh, you can use following code Sub CommandButton1() Sheets

Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-14 Thread Prajakt Pande
Dear Rakesh, you can use following code Sub CommandButton1() Sheets("your sheet name").Select 'first sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Sheets("your sheet name").Select ' where you want to paste Selection.PasteSpecia

Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-13 Thread Prajakt Pande
Dear Rakesh, Can you provide a sample sheet. Thanks & Regards, Prajakt Pande +971551388482 ** On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma < rakeshks@gmail.com> wrote: > Hi, > > Plz suggest me how i can merge two excel files data to single sheet using > command prompt. > > > -- >

$$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-13 Thread Rakesh Kumar Sharma
Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks & Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,