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 ( I want the macro to always choose the last row in column A as the last row will always change )

Now I need a macro code to copy the data from cell A4 ( the last row ) 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