Automatically copy some elements of data from one workbook to another

[debfrets]

Hi there...I have NO idea about VBA and i'm sure what i'm asking can be achieved very easily so please don't laugh!

Basically I run a daily report in excel and add the new data into an existing sheet, I want certain elements of this to be automatically copied into a seperate workbook so I can keep a second seperate database.

Book 1 contains the master sheet and Book 2 is to be specifically to track customer returns so I need the info of items we've swapped from book 1 - hope this makes sense and someone can help!

[Mumps1]

It would be easier to help and test possible solutions if you could attach copies of your 2 files. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.