Copy data from Workbook and save in existing Workbook in specific Sheet

[Chandresh]

Hi All,

Can any one help me with a macro which can copy the entire worksheet from one excel work book(workbook name is Data1) to current workbook in -Upload worksheet.

1) Both the workbook are saved on same path
2) My workbook name is constant and it will never change

Thanks
Chan

 

[keithmct]

Is the workbook "Upload" going to be open at the same time as "data1" or do you need it opened before copying?
Where in "Upload" do you want to put the copied worksheet? At the end? of before a particular sheet?
I did a simple macro recording of the following which might get you started (or raise more questions):

Sub copy()
'
' copy Macro
'

'
    Sheets("Sheet1").Select
    Sheets("Sheet1").copy After:=Workbooks("upload wb.xlsm").Sheets(2)
End Sub

 

[Chandresh]

Hi upload sheet is in macro workbook which is open , we need to copy the sheet from data1 workbook in macro workbook in upload sheet