Hi,

I currently have an excel document that when I press a button it runs a macro and saves a line of data to the end of a list in another sheet called DATACOLLECT. The data runs from B2 to F2, then after each button press the data is stored on the next line down.(B3 to F3 etc). What I want is another macro to call from the initial button press that will also save that last line to another workbook say called HISTORY and add it to the end of another list on say SHEET1 from cells P to T this time. Assume both files are in the same folder.

Can this be done?

Also if the History workbook is opened on another (networked) Pc will it cause an error as the files are stored on a network drive and usually cant be changed if they are open on another Pc?

Hope this makes sense.