How to copy and paste new data from one workbook to another

[Willows59]

Hi hope you can help, i am very new to VBA and what i am trying to do is copy data from Excel 2010 "Caister Daily Data"(Source workbook) Tab is Called "Data" columns B to AG, to an Excel 2010 "Caister Test" (Destination workbook) Tab is Called "Data" Columns C to AH, but only when new data is inputted into the source workbook. If possible the destination Workbook "Caister Test" would have a button to press to start this data transfer.

[sintek]

Perhaps this...Provided both files are in same path...
Put this code in Workbook "Caister Daily Data" Sheets("Data") sheet Module...
Everytime you enter new information when you add the last rows info in Col AG and press enter...That new row from column B to AG will be copied...and pasted to the Workbook called "Caister Test" Sheets("data") Column C from next new row...

Please Login or Register  to view this content.

[Willows59]

Perhaps this...Provided both files are in same path...
End Sub[/CODE]

Files are not in the same path the "Caister Daily Data" workbook (source file)has the following path "G:\AW_YH_US_NWW\Private\Stalham TM NSTS\Caister WWTW" and the "Caister Test workbook (destination file)has a path "H:\My Documents"

[sintek]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Are the folders in same path

[Willows59]

Sorry sintek i thought you meant the same path was are they in the same folders, which they have different holding folders. As i am missing something here (not hard in my case) can you explain what you meant by "same path" please as i am not sure exactly what you mean.

[sintek]

Are the folders in same path

My bad...got thread confused...

[Willows59]

Works a treat thank you for your help

[sintek]

Glad you got it sorted...Tx for rep +