Hello, I use this code in VBA to transfer data from one sheet to another when i click an option button. It however deletes the sheet each time I transfer new data. I need it to keep the old data, and trnasfer the new data to the next open row down? Thanks for all help.
Sub cpyToComplete()...