can you advise on code path please

[ipbr21054]

Hi,
Could you advise the code for the following please,i will then continue from there with the others i need to do.

I will add this to a button to transfer cell vales to my end of month sheet.

Worksheet called INCOME1
Copy cell value E32 & paste to Worksheet path shown below,

C,USERS,IAN,DESKTOP,EBAY,ACCOUNTS,PREVIOUS ACCOUNTS,2018 - 2019,SUMMARY 2018 - 2019,SHEET1, then cell E49

Thanks

 

[KolGuyXcel]

Same run time error message.

So i made this as simple as it ca possibly be to try and get it to work.
Two workbooks.

One called WB1
Only one worksheet inside called C

Other workbook called WB2
Only one worksheet inside called P

WB1 has a button with this code shown below.

Private Sub CommandButton1_Click()Workbooks("WB1.xls").Sheets(C).Range("A1").Copy _
    Destination:=Workbooks("WB2").Sheets(P).Range("A1")
End Sub

Yet i still get run time error 9 message.
Subscript out of range.

I cant see how or why this is so hard.
There must be something else which isnt allowing this to work.
These two workbooks WB1 & WB2 were both open but still i get run time error 9 message.

Try

Private Sub CommandButton1_Click()
Workbooks("WB1").Sheets("C").Range("A1").Copy _
Destination:=Workbooks("WB2").Sheets("P").Range("A1")
End Sub

No need to mention the .xls and need to include the "" with the sheet names.
HTH!

 

[ipbr21054]

Wow,

Now that worked thanks.

I will play a while then come back.

Have a nice day