Macro to copy one cell from one workbook and paste it in another cell in onother book

**Desmond_Mocumi** · 05-20-2013, 04:42 AM

Hi,

Can somebody help please.I need a macro to copy a cell C3 from workbook1 in a sheet named "IR&BS" and paste its value into cell E9 located in workbook2.I am new at this and I would greatly appreciate any assistance.

Regards
Desmond

**patel45** · 05-20-2013, 06:07 AM

put this code on a module of destination workbook, source workbook must be open

Sub a()
Set wb2 = Workbooks("workbook name")
Range("E9") = wb2.Sheets("IR&BS").Range("C3").Value
End Sub

**Desmond_Mocumi** · 05-20-2013, 06:40 AM

Thank u Patel I appreciate ur help!

Macro to copy one cell from one workbook and paste it in another cell in onother book

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to copy one cell from one workbook and paste it in another cell in onother book

Re: Macro to copy one cell from one workbook and paste it in another cell in onother book

Re: Macro to copy one cell from one workbook and paste it in another cell in onother book

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions