transfer current data from Sheet1 to Sheet2 via a button on Sheet1

[BJB_88]

Hi I am currently trying to copy a row of data from B3:K3 from sheet1 into the next empty row on sheet2. I need there to be a button on sheet1 that when clicked copies the current values across. The reason I need it done this way opposed from Ctrl+C, Ctrl+V is sheet1 contains a very large amount of data that is automatically extracted from a data base daily, at the end of each day ineed the current values displayed in B3:K3 transferred to Sheet2 for historical purposes. If anyone can help with this would be much appreciated

Thanks

[RudiS]

Hi,

See this sample file with macro...