a. BUS 311 Fall 2009 4. Macro: (45 points) Set A11 so that the only entries will be from the Credit Customer list provided in G16 - G29. b. Set B11 so that the only entries will be from the Product list in G11 - G13. Set C11 so that only positive whole numbrs may be entered. d. Set cells A11-C11 as the only cells the user can change when the sheet is protected. Protect this worksheet. f. Create a macro to: i. Copy A11 - E11. ii. Paste the copied values at the bottom of the "Transaction Log..." entries without overwriting any previous entry. iii. Clear the content of A11 - C11. iv. Leaves the worksheet protected. Place a button on this sheet to run the macro created in step f. Macro Point Possible: 45 February March January 460 307 June 314 484 446 414 April 366 264 May 458 495 361 298 Customer Adler Planetarium Credit Customer Order Entry Form Product Quantity Product Price Order Total Solar Mobile 2/ 5 11.95 $ 22.90 Shipping Rates by Region Product Price Night Disks S 19.95 Planet Cards S 4.95 Solar Mobile $11.95 Customer Cheung, Delia Hayashiguchi Standard Toki Middle School Transaction Lop of Individual Sales Product Quantity Product Price Order Total Night Disks 25 $ 19.95 $ 498.75 Planet Cards 200 S 4.95 $ 990.00 Solar Mobile 600 $ 11.95 $ 7,170.00 Credit Customer Adler Nanetarium Brulez, Emily Castleman, Doug Cheung, Delia Darbro, Heather Gerde, Edmond Hawthorne Academy Hayashiguchi Standard Hayes, Doug Lewis Museum Macey, Darrel Toki Middle School UTC Enterprises Wright Elementary