I am wanting to be able to enter invoice information into the first sheet of my excel file. This info will include order number, client, product name, date ordered, estimated ship date, and actual ship date.
Once the information is entered, I would like to have a calendar in excel format be automatically updated with the three different dates and the order information.
For example, let's say that I enter the following: Order number: 6894, Client: Bob, Product name: 5500 Series, Date ordered: 08/24/2010, estimated ship date: 09/30/2010, actual ship date: 10/03/2010. I would like the order number, client, and product name to show up on each of the three dates. So, on 8/24/2010 it would say ORDER RECEIVED, Order #: 6894, Client: Bob, Product: 5500 Series. On 9/30/2010, it would say ESTIMATED SHIP DATE, Order #: 6894, Client: Bob, Product: 5500 Series. And so forth.
What would be the best way to go about doing this? I am using Microsoft Excel 2002. Thank you very much for your help!