6. Ravi's plan is that when users click the Add Customer button in the range D3:E3, the Customers worksheet opens and Excel adds a new, blank record to the Customer table, where users can insert the new customer information. Record a macro to automate the Add Customer button as follows: Enable all macros in the workbook (if necessary), and then display the Developer tab on the ribbon. b. Record a macro stored in this workbook using Add_Customer as the name of the macro. a. C. d. While recording the macro, display the Customers worksheet. Also, while recording the macro, add a new blank record to the end of the Customer table. e. f. Stop recording the macro. Assign the Add_Customer macro to the Add Customer button and then run the Add_Customer macro to make sure it inserts a new record at the bottom of the Customer table on the Customers worksheet. Home Insert Draw Page Layout Formulas Data Review View Developer Tell me OD Get Add-ins H? . V 2 Pivot Table Recommended Table PivotTables Pictures Shapes Icons Avd. Recommended Charts Data from Picture My Add-ins Maps F M1 X fx X A B C D E F G H 1 L M. N o P o R S FN Home Security Systems Contracts by City Atlanta College Park Dunwoody 1 2 ID Customer First Last Phone Address City State Zip 3 C-001 Margaret Alexander 770-866-3901 212 N Paterson Newnan GA 30263 4 C-oos Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 30270 5 C-oo8 Chris Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA 31107 6 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 30004 7 C-014 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 8 C-015 Alberto Cruz 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-6808 815 Pulley Rd Decatur GA 30031 LO C-027 Karen Li 706-487-9244 402 S Melody Rd Augusta GA 3091B 1 C-030 Stephen Rosner 770-393-1228 112 E 18th Ave Dunwoody GA 30346 12 C-031 Daniel Plummer 404-842-4603 29 Graham Blvd Atlanta GA 30347 13 C-032 Laquan Richardson 404-857-1276 8o Cedar St Atlanta GA 30350 24 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 15 C-040 Victor Ramirez 770-988-077 144 E Tower Ave Holly Springs GA 30115 46 C-042 Michael Levander 404-337-9208 10 Lincoln Dr Atlanta GA 30336 17 C-043 Shana Liang 770-98B-1320 40 Monroe St Alpharetta GA 30022 18 C-045 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta GA 31156 19 C-048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 30919 20 C-049 Frances Heller 404-983-2255 828 Turner St College Park GA 30337 21 1 C-053 Ahmad Greenwell 770-395-8401 614 Berman Rd Douglasville GA 30134 22 C-054 Jacquie Rollins 770-355-3989 258 Briar Ln Woolsey GA 30214 3 C-055 Steve Tomashek 404-979-2004 404-979-2004 1440 Beadle Rd Decatur GA 30036 24 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta 30907 25 C-059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta GA 30339 26 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 27 C-066 Douglas Shoemaker 706-487-4700 5478 N Grove Baldwin GA 30511 28 C-065 Raymond Ringdahl 770-393-0403 24 Samuel St Alpharetta GA 30009 29 C-067 Beth Raferty 404.985-1992 612 E Carolina Pl Atlanta GA 30318 80 C-068 Jason 770-454-4002 5230 Fulton St Carrollton GA 30119 1 C-070 Gordon Griffin 706-456-7093 912 Market St Augusta GA 30907 32 C-on Mia Watanabe 404-857-4424 82 Cambridge St Briarcliff GA 30329 3 C-072 Barbara Callahan 404-337-8200 5049 Hwy 36 Sandy Springs GA 30342 94 C-073 Randy Dixon 770-983-1116 132 Pleasant St Marietta GA 30090 55 C-075 Jim Benning 706-482-99322167 S Macon St Augusta GA 30168 36 C-079 Sarah Alvarez 770-940-33B0 620 Pinewoody Alpharetta GA 30412 87 C-080 Timothy Jones 404-392-4629 249 Waath St Atlanta GA 30322 8 C-083 Shanissa Hoffman 706-337-0990 1286 Jennifer Dr Athens GA 30604 39 C-084 Cathy Wilson 770-866-4882 78 Sandy Springs St Buford GA 30515 Co C-8 Richard Phillips 770-637-5408 39 Water St Canton GA 30114 1 C-087 Nancy Wanson 404-963-6190 1752 S Main St College Park GA 30337 2 C-088 Mickey Kervin 706-454-2227 228 N Oak St Columbus GA E1998 -3 GA Grady 15 -6 7 EB 59 52 53 54 55 56 Documentation Home Page Sheet3 Sheet4 Customers Contracts Invoices +