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 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