Excel excel functions

[caroll]

--------------------------------------------------------------------------------

How can I write a speadsheet driven by VBA for a small office supplying 3 products, the system be used to keep track of the sales the company make.The system can use excel worksheets to display data and should create any graphs onto worksheet, provide some GUI functionality to allow easy control of the system, have controls embedded into a worksheet or user form with controls on it, and also save its records to an access DB and the database be updated whenever records are deleted, added or modified. The records that the systems keeps track of contain information such as; salesperson's lastname, company name, product name,product cost, quantity bought, total cost, discount, date. The system provide functionality such as; display all data, add a new sales record(calculating total cost automatically, including discount where applicable), delete a sales record, show company data, etc.

[martindwilson]

practice alot ?
but seriously you should realy take this one step at a time try just creating the basic workbook first.

[caroll]

I have created the basic workbook and recorded a macro, how do edit the macro to accomodate the functionalitys needed?

[martindwilson]

repost with a specific question in the programming sub forum