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.

Hi,

Yes it's possible. Either via VBA (I wouldn't know where to start helping you with that) or with a formula approach.

It may mean the addition of at least one helper column but it could be hidden away so it doesn't cause confusion.

If that's acceptable, you'll need to provide some sample data (with no sensitive data included). Either post it here or email it to pubnut @ gmail . com (without spaces and I'll see if I can provide a working example for you.