How can I write a speadsheet driven by VBA for a small office supplying 3 products (box of books, box of pens and box of rubbers), 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 a userform with controls on it, and also save its records to an access DB and the database be updated whenever records are deleted, added or modifified. 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 of 0-100 = 0%, 101-150 = 2%, 151-200 = 4% and >200 discount of 5%), delete a sales record, update prices (each year the company raises the cost of products by 5% for <500 units and 10% for >= 500 units), show sales performance, show company data, staff sales performance, staff bonus earnings, company purchase history, product performance. Should write VBAcode to automate the functionality where possible, should use built in Excel fuctionality where relevant or use SQL calls to retrieve particular subsets of the data.
Reply With Quote
