In the spreadsheet I am going to design I am going to use the following 'Source Data'. The data to go into the catalogue has been supplied by the company.
Member rating:
(3 votes)
| Words:
| Submitted: Fri Aug 15 2003
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Design Plan In the spreadsheet I am going to design I am going to use the following 'Source Data'. The data to go into the catalogue has been supplied by the company. The data to be used is written below: The information in the table will be displayed on four different spreadsheets but they will be used in different contexts. On one of the screens it will be displayed as it is above, as a simple list of options. On other screens it will be used as a form of stock control, an order form and as a list on an invoice. Another function that I will use on some of my spreadsheets is the AutoSum. This will be used to add up the price of all of the items odered on the Order form. In the workbook I am going to create I will use macros to make the user interaction to a...

