I have two workbooks, one of them is a template for invoices and the other is
for tracking those invoices. When I need an invoice I go to €œInvoice09€� and
open a new workbook, fill it in and €œsaveas€�. I use the address and apartment
number as the file name. I then go to €œInvoice totals€� and enter the data
into the appropriate cells. I would like to automate the process of saving
as the address and apartment number and moving the data from the newly
created invoice to the Invoice totals workbook. The layout of the key cells
a C19 is the address, C20 is the apartment number, K6 is the date, and L52
is the total for that invoice. In the Invoice totals workbook the key cells
a Column B is the Saved AS file name, Column C is the invoice date, and
Column D is the total for each invoice. I really wish I spoke vba but€¦.. I
dont. Can some one help me out with some direction?

Mike Rogers