Copy from One Workbook to another Workbook

[rlcurlee67]

I have a daily report I have to fill out based on daily report sheets sent in.

So,

I have workbook "ABC" (which is my report of daily readings) and I need to copy from workbook "123" cell B45 (which is my daily sheet) and paste in workbook "ABC". I'm not an expert on formulas or macros. Can you please advise on what I should do.

 

[somers]

Try this:

workbooks.open "C:\yourpath\123.xlsx"
workbooks.open"C:\yourpath\abc.xlsx"

workbooks("123").worksheets("1").range("B45").copy
workbooks("abc").worksheets("1").range("A1").pastespecial paste:=pasteformats