Complex spreadsheet model, Business Management

Refine your complex spreadsheet model to improve efficiency.

a) The user needs to enter at least one of the following contact details: Home Phone, Mobile or E-mail address. If all of these have been left blank, then the user needs to receive feedback to ensure that they enter one value.

The maximum garden length, width and radius, Gareth can cater for are:

Length 1000m

Width 750m

Radius 200m

Implement validation to ensure that user entry does not exceed these values.

b) Implement password protection into you workbook to ensure that no unauthorised persons can access the data.
P5

c) Add two additional sheets to your workbook - one named Invoice and the other named Menu.

d) Add macro buttons to each of the four worksheets to enable the user to fully navigate around the workbook. Include a Quit button on the menu.

Posted Date: 3/25/2013 1:55:28 AM | Location : United States







Related Discussions:- Complex spreadsheet model, Assignment Help, Ask Question on Complex spreadsheet model, Get Answer, Expert's Help, Complex spreadsheet model Discussions

Write discussion on Complex spreadsheet model
Your posts are moderated
Related Questions

Use VBA code that will be triggered on the click of a button on the order sheet, to add the order for each garden to the Sales Database sheet. Produce a written comparison of sp

Q. Competitive strategies for Information system? Business is capable to develop competitive strategies to counter the action of the competitive forces they confront the market

#questionList out the secondary sources of information while pursuing market research..

(a) Define the concept and goal of the Extraction, Transformation, and Loading (ETL) functionality in relation to the Data Warehouse (DW) solution.  As part of your answer, briefl

Accidents  are  usually the  results  of a combination of  factors each one of which  may very  from  situation. An  accident  does no have  a single cause but  multiplicity  of ca

explain the rating plan method of plant location

Briefly explain any five qualities of an outsourcing project leader. 1. Ability to embrace and support change. 2. Earned credibility across the organization. 3. A desire

What are the functions of Trade Unions? The functions of trade unions are as follow: a. The provision of friendly services as like a place for leisure pursuits, information

QUESTION a) Expand the term B2B and B2C. Give one example of each type of business that each represents. b) Compare traditional commerce with electronic commerce and explain