Auto filling across multiple worksheets

[Pililuk]

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

 

[Spencer101]

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

Hi,

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

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

If that's acceptable, you'll need to provide some sample data (with n
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 workin
example for you