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 the bottom right corner...:)