Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. Record a Macro, QUESTION9 to sort the database by age of employee within each Department (department should be sorted in ascending order, and age

9. Record a Macro, QUESTION9 to sort the database by age of employee within each Department (department should be sorted in ascending order, and age should be descending order). Be sure you dont sort a column independently of the records!!! Create macro button in Database sheet.

image text in transcribed

Please provide steps/formula(s) so I can solve the question. Thank you!

B D E F M N 3 4 3 6 06 07 08 7 New Salary i Now Salary 2 Birth Month La Na Fine Name Crim bal Lisa Divison Copier Eme 10 1011 1012 1041 1034 Department Accounting Engineering Land D Salary $27, 37.5 $45,315 Birth Date 11/21 Hin De 200 1/2 Service 21 15 19 10 inter W21/08 35 41600 15 12 25 1706 S6 12 Martin Copiar 95 1085 JUTS 115 41 1/21/ 10/2017 4x 21 Ace Account Martin inter hinter Copier SEK 57 12 20 IN 90 14 15 16 17 18 19 1155 1167 110 1100 $31,913. 90 410 10/1 Engineering Copter 356, 01.05 113. K. 1200 129 54 7770 7V12 10/1/66 WIS W2468 15 15 Tercan Smith Horward Albert Maxim Sheryl Indra Mark Allen Skrwick Sam To krery Cooper Linde Simp tichande any Smith Ellen Nuts Varm Tues Slack Cash Mary Pranck Ta Kanck Midori Laptor Pets Bell To Cepler hinter 12/21/05 12 1400 21 22 35 Accounting Marketing 90 12 104 11/27 55 24 Marketing 0,251. $27,01.04 32.410.5 $45,95 356, 4105 $31,339.24 SANT2.15 1310 1311 13 1330 1351 IK 2/22,00 37 12 Accounting 26 27 52 inter Cape Printer Copter 92363 90 21 55 1354 Engineering La Marketing 1076 10 IRS SEK, 29 30 31 32 55 35 17 Printer SEK, SA 30 30 57 37 Engineering 1516 1517 1509 1930 1931 77 W1071 Kellerman Tomis 1/2 UT 14 34 Printer Printer Copier 54 1/1967 4 Lerupert David Bass Alexandra Karen 36 37 15 1557 22 Evelyn Copier Copter Printer 9 15 Walla S419.40 2. O $27.7. 10/10 1/17 15 40 41 42 NIK 10/1605 12 1250 317196 10/2 10/IROL 117UT Martin Accu Acco Account Martin Admin Land 41 57 lanct 1/60 Copier Capler Melek Miller Walla Levin Alain Chu 3,101.44 $28,21232 $37.995.52 19 13 44 Eric WI 16657 1674 1675 1675 1676 1677 1725 1724 Ime 1745 1794 IKIA IKIO 1951 55 46 47 Printer Capler Reven ten Aaron Malcolm Bar Aks Colder Al-Sabah Marketing Art Armin Marketing SEKS. Sax, 39.25 247.50 357.75 351, S. 35.40 7V2AVT 12/24 121 14 17 52174 10 10/1476 10/ Michael 7 IK Mallar 49 50 51 52 53 54 35 56 57 Copier Copter 11/13 27.01.04 4265 14 Accounting Acco Admin Ant Armin Market 11/1791 VI kan Macier Corwick Felics Martin Sara Larry retry Maguire Mollis verlay 1967 1975 Capler Copter Copier Printer Copier 3717 $25,212.32 $35.9.20 $21, T.95 $35,038. SD 351, NTKA 5/15 3/1960 92x70 10W W21/ 19 197 19TT 197 WI Engineer Ant Engineering 1/5 10/IKSI 13 B D E F M N 3 4 3 6 06 07 08 7 New Salary i Now Salary 2 Birth Month La Na Fine Name Crim bal Lisa Divison Copier Eme 10 1011 1012 1041 1034 Department Accounting Engineering Land D Salary $27, 37.5 $45,315 Birth Date 11/21 Hin De 200 1/2 Service 21 15 19 10 inter W21/08 35 41600 15 12 25 1706 S6 12 Martin Copiar 95 1085 JUTS 115 41 1/21/ 10/2017 4x 21 Ace Account Martin inter hinter Copier SEK 57 12 20 IN 90 14 15 16 17 18 19 1155 1167 110 1100 $31,913. 90 410 10/1 Engineering Copter 356, 01.05 113. K. 1200 129 54 7770 7V12 10/1/66 WIS W2468 15 15 Tercan Smith Horward Albert Maxim Sheryl Indra Mark Allen Skrwick Sam To krery Cooper Linde Simp tichande any Smith Ellen Nuts Varm Tues Slack Cash Mary Pranck Ta Kanck Midori Laptor Pets Bell To Cepler hinter 12/21/05 12 1400 21 22 35 Accounting Marketing 90 12 104 11/27 55 24 Marketing 0,251. $27,01.04 32.410.5 $45,95 356, 4105 $31,339.24 SANT2.15 1310 1311 13 1330 1351 IK 2/22,00 37 12 Accounting 26 27 52 inter Cape Printer Copter 92363 90 21 55 1354 Engineering La Marketing 1076 10 IRS SEK, 29 30 31 32 55 35 17 Printer SEK, SA 30 30 57 37 Engineering 1516 1517 1509 1930 1931 77 W1071 Kellerman Tomis 1/2 UT 14 34 Printer Printer Copier 54 1/1967 4 Lerupert David Bass Alexandra Karen 36 37 15 1557 22 Evelyn Copier Copter Printer 9 15 Walla S419.40 2. O $27.7. 10/10 1/17 15 40 41 42 NIK 10/1605 12 1250 317196 10/2 10/IROL 117UT Martin Accu Acco Account Martin Admin Land 41 57 lanct 1/60 Copier Capler Melek Miller Walla Levin Alain Chu 3,101.44 $28,21232 $37.995.52 19 13 44 Eric WI 16657 1674 1675 1675 1676 1677 1725 1724 Ime 1745 1794 IKIA IKIO 1951 55 46 47 Printer Capler Reven ten Aaron Malcolm Bar Aks Colder Al-Sabah Marketing Art Armin Marketing SEKS. Sax, 39.25 247.50 357.75 351, S. 35.40 7V2AVT 12/24 121 14 17 52174 10 10/1476 10/ Michael 7 IK Mallar 49 50 51 52 53 54 35 56 57 Copier Copter 11/13 27.01.04 4265 14 Accounting Acco Admin Ant Armin Market 11/1791 VI kan Macier Corwick Felics Martin Sara Larry retry Maguire Mollis verlay 1967 1975 Capler Copter Copier Printer Copier 3717 $25,212.32 $35.9.20 $21, T.95 $35,038. SD 351, NTKA 5/15 3/1960 92x70 10W W21/ 19 197 19TT 197 WI Engineer Ant Engineering 1/5 10/IKSI 13

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance Brief

Authors: Chad J. Zutter, Scott B. Smart

8th Global Edition

1292267143, 978-1292267142

More Books

Students also viewed these Finance questions

Question

What is Big Data? AppendixLO1

Answered: 1 week ago

Question

4. Analyzing: Breaking something down into its parts.

Answered: 1 week ago

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago