VBA copy data from one workbook to anotherworkbook

[GEmbers]

I need to copy data from workbook a starting at line 2 and paste to workbook b starting at line 3. I would really like your advise please I have been trying to piece together other answers to get my answer but am failing

 

[oldbrewer]

does it need to be a different workbook - eg why not a new sheet in existing workbook?

but - in workbookB cell A3 insert formula

=workbookA!A2

then copy this across and down as needed. workbookB will now update automatically to any change in workbookA

 

[GEmbers]

does it need to be a different workbook - eg why not a new sheet in existing workbook?

but - in workbookB cell A3 insert formula

=workbookA!A2

then copy this across and down as needed. workbookB will now update automatically to any change in workbookA

HI thank you this is weekly metric reporting workbook (a) comes into a mail box from a data extraction server, it is manipulated and then copied over to the data load worksheet in the metrice workbook (b). The final piece of my VBA is to get this copy working working.

 

[oldbrewer]

metrice workbook (b) will always be a copy of metric reporting workbook, updating every time a change is made - you don't need to copy it at all, surely?