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.
--
Thanks
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.PasteSpecial
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(your sheet name).Select 'first sheet from you will copy the data
Range(Selection