I am using Excel 2003 and I have a lot to learn.

I have two workbooks. One is a QUOTE WORKBOOK and on is a JOB RECAP. The
QUOTE WORKBOOK is used to quote and process jobs. It contains a series of
worksheets. Once the information about the specific job is entered it is
saved as the €œjob name€�. The JOB RECAP is a running total of the jobs sold.

I would like to automate the process. I would like to add a cell on the
QUOTE WORKBOOK so that when I enter €œActive€� it will €œsend€� info to the JOB
RECAP sheet like €œJob name€�, €œInvoice amount€�, etc.

Is this possible? If so How?

Thanks in Advance.

Steve