Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BUS 311 Fall 2009 4. Macro: (45 points) a. Set A1 1 so that the only entries will be from the Credit Customer list provided

image text in transcribed
image text in transcribed
BUS 311 Fall 2009 4. Macro: (45 points) a. Set A1 1 so that the only entries will be from the Credit Customer list provided in 616 G29. b. Set B1 1 so that the only entries will be from the Product list in G 11 613. c. Set C1 1 so that only positive whole numbrs may be entered. d. Set cells A1 1C1 1 as the only cells the user can change when the sheet is protected. e. Protect this worksheet. f. Create a macro to: i. CopyAllEll. ii. Paste the copied values at the bottom of the "Transaction Log entries without overwriting any previous entry. iii. Clear the content of A1 1 C1 1. iv. Leaves the worksheet protected. g. Place a button on this sheet to run the macro created in step f

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Science The Art Of Modeling With Spreadsheets

Authors: Stephen G. Powell, Kenneth R. Baker

3rd Edition

0470530677, 978-0470530672

More Books

Students also viewed these Finance questions