60.1K

Verified Solution

Link Copied!

Hi I need a detailed explanation on how to do this step by step

1) In the Sales flep Name tard, create a drop down list of names that are on the "Satestiar" shest. 2) Enter test data for the Sales Rep Name, Sales Dato and Sales Amount. IMake the data upl Stive be file. Hint You will need fir Paste Values' for the Cemmitsion amount or it will not paste cocrecey. 4) Wake sure the formattine on both sebles fooksi right after vou are dore pastiris 5) Clear the tevt deta cells so therare empey for the nest eniry. Hine: The solution yoo desien eo create the graph, may require the disn be refreshed periedially. That is accepeablo [7) Write a inacro with o button to automate the updating of the sales Uus table. 8) Tent your macro with a couple tranutiom to envure it a working ar plussed. 3) Save your file as a "Mucro- Enabied Excel file" and submit for grading: 6) On either sheet, create a column of bar chant of the Comminion table that shows cach Rep's performance. - Make sure that yoar groph will update as future transactions are added to the lint, (To do tho, whicn you highight the graph rarge, inchude abo blank rass below) Stue the fil Hint. The solution you desicn to create the graph, may require the date be refredied periodically. That is acteptable. 7) Write a macro with a button to automate the updating of the Sales ligt table. - The clerk enters the three trancaction details and then hits your macro button to update the table on the Saiedist aheet. - The macro khould copy the data from the Entry Form to the Commission table and leave the Entry form blank and the cunaer siting in the Salvs fiep Name field ready for the neat transketion. - The macro should paste each new entry at the bottom of the table, below the prevous entry. It should not overwitie any tramactions in the table. When: Remember that if you slick on the top row of the table and tic "End Down"; vour curser will fump to the bottom of the table na ratter how lang it is a) Test your macro with a couple transations to ensure it is working as planned. 9) Save your file as a "Macro- Enabled Excel file" and submin for wrading. 1) In the Sales flep Name tard, create a drop down list of names that are on the "Satestiar" shest. 2) Enter test data for the Sales Rep Name, Sales Dato and Sales Amount. IMake the data upl Stive be file. Hint You will need fir Paste Values' for the Cemmitsion amount or it will not paste cocrecey. 4) Wake sure the formattine on both sebles fooksi right after vou are dore pastiris 5) Clear the tevt deta cells so therare empey for the nest eniry. Hine: The solution yoo desien eo create the graph, may require the disn be refreshed periedially. That is accepeablo [7) Write a inacro with o button to automate the updating of the sales Uus table. 8) Tent your macro with a couple tranutiom to envure it a working ar plussed. 3) Save your file as a "Mucro- Enabied Excel file" and submit for grading: 6) On either sheet, create a column of bar chant of the Comminion table that shows cach Rep's performance. - Make sure that yoar groph will update as future transactions are added to the lint, (To do tho, whicn you highight the graph rarge, inchude abo blank rass below) Stue the fil Hint. The solution you desicn to create the graph, may require the date be refredied periodically. That is acteptable. 7) Write a macro with a button to automate the updating of the Sales ligt table. - The clerk enters the three trancaction details and then hits your macro button to update the table on the Saiedist aheet. - The macro khould copy the data from the Entry Form to the Commission table and leave the Entry form blank and the cunaer siting in the Salvs fiep Name field ready for the neat transketion. - The macro should paste each new entry at the bottom of the table, below the prevous entry. It should not overwitie any tramactions in the table. When: Remember that if you slick on the top row of the table and tic "End Down"; vour curser will fump to the bottom of the table na ratter how lang it is a) Test your macro with a couple transations to ensure it is working as planned. 9) Save your file as a "Macro- Enabled Excel file" and submin for wrading

Answer & Explanation Solved by verified expert

See Answer