so I've had a look and cant seem to find what I am after, Hoping an Excel Guru can Help ?

So at the end of each day I need to be able to use a Macro which will copy all the rows of data for that Date across to an Existing workbook, Pasting the rows to the next free Line in that work book.

I do have a userform connected which a user uses to log the data
Wondered if this can be added to the CMDOk so when it writes the data to the Sheet it also copies to the Other master work book ?

*Note the user may go into the record 5 times in that day Via the userform to update dater so if the record is copied across as the 1st CMD Ok then I need the record that has been duplicated to the master workbook to be updated also?

Please help