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

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

  • Hi,


    Only a simple Copy instruction ... as long as you are dealing with opened workbooks ...


    If it is not case ... it will require a different approach

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)