VBA to copy cell value from the last row of the workbook to another workbook

[shernel07]

Hi there,

I have two workbooks eg. Data.xlsx and Final.xlsx

In Data.xslx I have the sum of A2:A3 in cell A4

Now I need a macro code to copy the data from cell A4 and transfer it to the Final.xlsx workbook in cell A4 for example.

P.S I need to data to get transferred not the formula present in A4.

Can you guys help me in this? Thanks

 

[shernel07]

I followed your steps but it throws me an error Subscript out of range, run time error 9 and it highlights Set wb = Workbooks("Data.xlsx") in the debug option.

 

[Danmc]

I followed your steps but it throws me an error Subscript out of range, run time error 9 and it highlights Set wb = Workbooks("Data.xlsx") in the debug option.

is Data.xlsx open? if not, it needs to be open for this macro to run properly.

 

[shernel07]

Yes it worked I used to Open and Close function for it to partially open the data and get it populated. And thanks alot man. You are an angel!
Keep up the good work.

 

[Danmc]

thanks for the comment and mention. good luck in your endeavors.