Forum Discussion
Pulling Data from one workbook to another
I know this question has been asked before but I'm very new to this so I'm having trouble following the lingo:
I want to pull Data from a workbook with a contract on (with no set name as diff contracts have different names) into another workbook with a table on. This table then converts into an email (which I am able to do).
However I'm having trouble trying to get the vba to copy the data from one cell in one book to another in the other book. I've tried a few codes but the latest I've been trying is:
ActiveWorkbook.Worksheets("Page One").Range("C3").Copy _
ThisWorkbook.Worksheets("Pull").Range("C11").Value
Any ideas or tips are very welcome, again I'm very new to this.
I want to pull Data from a workbook with a contract on (with no set name as diff contracts have different names) into another workbook with a table on. This table then converts into an email (which I am able to do).
However I'm having trouble trying to get the vba to copy the data from one cell in one book to another in the other book. I've tried a few codes but the latest I've been trying is:
ActiveWorkbook.Worksheets("Page One").Range("C3").Copy _
ThisWorkbook.Worksheets("Pull").Range("C11").Value
Any ideas or tips are very welcome, again I'm very new to this.
8 Replies
You don't need the .Value:
ActiveWorkbook.Worksheets("Page One").Range("C3").Copy _ ThisWorkbook.Worksheets("Pull").Range("C11")- Ah okay, I took that out but it's still throwing up an error 438
How about
ThisWorkbook.Worksheets("Pull").Range("C11").Value = ActiveWorkbook.Worksheets("Page One").Range("C3").Value
