"George" wrote:

I am looking for a way to keep track of invoices that are entered on an excel
spreadsheet automatically. These invoices are used as quotes and we are
required to keep a quote log. Iam lookginf for a way that would enable me to
keep a record of every quote that is entered without having to physcially
input the data in another work book.

Hi there,

This link may help:
http://www.vbaexpress.com/forum/show...hlight=invoice

HTH