Question: Please explain it using excel and formulas needed. Thank you Create a MACRO that will populate the table on Worksheet 16(b) with the data entered
Please explain it using excel and formulas needed. Thank you
| Create a MACRO that will populate the table on Worksheet 16(b) with the data entered into the blue cells below on Worksheet 16(a). Insert a button control that says "Click Here" per the prompt below. Make sure that (1) the rows in the Worksheet 16(b) table are populated properly (i.e., multiple rows will populate instead of data being entered into the same row repeatedly) and (2) your MACRO will function correctly if run repeatedly. | |||||||||
| MACRO INSTRUCTIONS: With macros enabled, enter relevant information into blue cells below, then click "Click Here". | 1:00 | ||||||||
| Date | 10010023 | 2:00 | |||||||
| Employee ID | 10857690 | 4:00 | |||||||
| Clock-in | 14549987 | 6:00 | |||||||
| Clock-out | 19756988 | 7:00 | |||||||
| Time Card Information | |||
| Date | Employee ID | Clock-in | Clock-out |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
