create a datafile

[acki]

Hello,

I work for a small organisation and I am trying to make admin stuff a bit easier and smoother. So for instance when I write an invoice in excell, I would like excell to autopmatically also save the data of each individual invoice in a separate file where I keep an overview of all invoices.
So for instance I make an invoice called invoice1.xlsx, and I want invoice number, date, name and amount also to be saved in overview.xlsx, one row for each invoice...



Thanks

[Pecoflyer]

Hi

why don't you work the other way ?
Create a database in Excel and use MSWord Mail Merge to create your invoices ?
This will save you lots of work and errors :-)