[Solved]Develop Vba Program Following Provides User Choice Operations Enter List Names Sales Value Q37169947
Please help! Show all answers, steps, screenshots on excel!
Develop a VBA program that does the following: Provides the user with a choice of operations: Enter a list of names and sales values each in a column on a spreadsheet. The data is entered by the user via inputbox. Sort: The list will be need to be sorted by names. See the code for sorting Find the largest sales value in a list Find the smallest sales value in a list Update or insert based on the list of names with sales values (by column) 1. 2. 3. 4. 5. Provide an update capability-user selects to Update or to Delete a. If change a sales value associated with a given name (which the user provides). You then find the name and change the associated sales value which the user provides I delete for a given name (which the user provides) you find the name in the column and delete the name and associated sales value i. ii. b. Insert a name into the names list with associated sales value. You will want to keep the names in a sorted order by names. You will provide all the data for your program This will requires several components: 1. Getting data from the user and posting on a spreadsheet 2. Sorting 3. Searching for a specific value 4. Finding the smallest or largest in a list 5. Changing cell values on a spreadsheet. 6. Moving data around on a spreadsheet Show transcribed image text Develop a VBA program that does the following: Provides the user with a choice of operations: Enter a list of names and sales values each in a column on a spreadsheet. The data is entered by the user via inputbox. Sort: The list will be need to be sorted by names. See the code for sorting Find the largest sales value in a list Find the smallest sales value in a list Update or insert based on the list of names with sales values (by column) 1. 2. 3. 4. 5. Provide an update capability-user selects to Update or to Delete a. If change a sales value associated with a given name (which the user provides). You then find the name and change the associated sales value which the user provides I delete for a given name (which the user provides) you find the name in the column and delete the name and associated sales value i. ii. b. Insert a name into the names list with associated sales value. You will want to keep the names in a sorted order by names. You will provide all the data for your program This will requires several components: 1. Getting data from the user and posting on a spreadsheet 2. Sorting 3. Searching for a specific value 4. Finding the smallest or largest in a list 5. Changing cell values on a spreadsheet. 6. Moving data around on a spreadsheet
Expert Answer
Answer to Develop a VBA program that does the following: Provides the user with a choice of operations: Enter a list of names and … . . .
OR
