hello

i bassically wanted to know if theres a way that if i click the button ie macro then it would save the current worksheet on a new workbook so the button would open the workbook and save the worksheet on to it

for example

if i was creating a finacial spreadhseet and i wanted to keep a record of all the invoices before the date is cleared, i would need a button that would open another workbook and cave the invoice on that

thanks in advance