Having just started a new job i have come across a problem that im not too sure how to solve.
Essentlly i have an invoice and quotes spreadsheet with alot of entrys for invoices to the same company.
I wish to have an additional sheet for each company aswell as the main page that has all the invoices for every company.
So far i have manual transfered about half of the data but was wondering if theres a method to firstly have it automatically add the old data to the right sheets.
Secondly if i was to add a new invoice would it be posible to have it automatically add to the right companys sheet.