Computers and Technology

How do you do the below?

i. e. click view than click macros, record macros, etc. i'm stuck from there.

record a macro named roomsort. the macro should copy the range a4: k46 from the sequential worksheet and paste the data in cell a4 of the room worksheet. do not stop the recording after this step.

with the macro still recording click cell a4. on the data tab, in the sort & filter group, click sort. using the sort dialog box, sort the data by room in alphabetical order. add a second level sort that sorts the days column using the following custom sort order: mwf, mw, m, w, tr, t, r, s. add a third level sort that sorts the start time column from earliest to latest. return to the sequential worksheet, click cell a1 and stop the recording. save the workbook as a macro-enabled template.

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 14:30, chaparro0512
Create a pseudocode design to prompt a student for their student id and the titles of the three classes they want to add. the solution should display the student’s id and a total bill. • bill a student using the following rules: o students can only add up to 3 classes at a time.
Answers: 3
image
Computers and Technology, 23.06.2019 00:00, destinysmithds7790
Suppose you have 9 coins and one of them is heavier than others. other 8 coins weight equally. you are also given a balance. develop and algorithm to determine the heavy coin using only two measurements with the of the balance. clearly write your algorithm in the form of a pseudocode using the similar notation that we have used in the class to represent sorting algorithms
Answers: 1
image
Computers and Technology, 23.06.2019 16:30, azainababbas
20 points archie wants to use a reflector as he photographs a newlywed couple. what would he consider in his choice? a. shadow and sunny b. homemade and professional c. lamps and boards d. incident and reflected e. neutral density and enhancement
Answers: 3
image
Computers and Technology, 23.06.2019 19:00, jacobbecker99
Choose the correct citation for the case which established the "minimum contacts" test for a court's jurisdiction in a case. select one: a. brown v. board of education of topeka, 347 u. s. 483 (1954). b. international shoe co. v. washington, 326 u. s. 310 (1945) c. haynes v. gore, 531 u. s. 98 (2000). d. international shoe co. v. washington, 14 u. s. code 336.
Answers: 1
Do you know the correct answer?
How do you do the below?

i. e. click view than click macros, record macros, etc. i'm st...

Questions in other subjects:

Konu
Mathematics, 05.05.2020 11:11
Konu
Mathematics, 05.05.2020 11:11
Konu
Mathematics, 05.05.2020 11:11