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