Also, you are required to redesign the Invoice Worksheet as asked below. Then you are required to copy information that

[answerhappygod]

Also, you are required to redesign the Invoice Worksheet asasked below. Then you arerequired to copy information that is in Invoice and Paste it intothe Transactionworksheet. Please keep in mind that you are creating a simpleInvoice to transactionworksheet (and not the advanced one that requires the use of DIMand Do Untilfunction). See the guidelines and questions below:a. In the invoice worksheet: (10 points)i. Cell B7 should have a date function that gives today’s date(andautomatically shows today’s date every day we open the excelfile).ii. Cell K15 gets values from the multiplication of G15 andI15.iii. In Row 15 of Invoice worksheet, the “ProductID” should be adropdownlist from the Items worksheet. Also, based on ProductID, you shoulduse aVLOOKUP function to fill out (or borrow) the information inProductType column and ProductPrice column given on Invoiceworksheet (Note: NO need to combine this with IF and IsBlankforquestion (ii.) or (iii.) above; just write Vlookup ormultiplication formulaas asked by question).b. Row 19 in Invoice worksheet already has a checkbox called“Shipping Charge?”.However, as of now, that checkbox is not functional. Please writeVBA codeinside the box as we learned in class to make it functional. Whenchecked on it, itshould add $10 to K19; when unchecked it should give $0. (5points)c. Now, write VBA code that allows to copy and paste informationfrom Invoice toTransactions worksheet. Only copy and paste those information anddata that arebeing asked in Transactions worksheet. Again, please keep in mindthat you arecreating a simple Invoice to transaction worksheet (and not theadvanced one thatrequires use of DIM and Do Until function). When copying andpasting, theformatting should not be copied. Employee information is not given– thus, putany name such as Carson. Create a macro button for it so that userscan click torun this function. (20 points)
3Note: For the question above, NO need to create “Clear” button toclear data thatis on Invoice as the question isn’t asking that. Also, please writethis VBA codeinside Module