Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2


    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 ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment

    Working...
    X