I am a newbie to macros and know nothing
I have two workbooks with the same data ranges. One of them updates with new rows of data constantly which then needs to be copied and pasted into the other workbooks data. I need to create a macro that copies the data from where the new data starts (in the workbook that updates) and pastes it in the other workbook sheet at the end of the old data.
Is it possible to create macros that grab from one workbook and paste in another?
If this macro is possible could I add a function that drags down a vlookup formula at the far right of the data to the bottom of the new data (just for maximum efficiency)
Thanks
Bookmarks