Icon

Windows Explorer and Microsoft Excel Guide

This is a step-by-step guide for Windows Explorer and Microsoft Excel

By Monika Pakalniskyte
1
Open current week's folder
Step #1: Open current week's folder
2
Copy "TRU TAC MASTER NEW WK MACRO"
Step #2: Copy "TRU TAC MASTER NEW WK MACRO"
3
And paste it to the 'Master sheet - Depot' folder
Step #3: And paste it to the 'Master sheet - Depot' folder
4
As the current week's sheet is saved for the back up, just replace it when saving
Step #4: As the current week's sheet is saved for the back up, just replace it when saving
5
Then the sheet needs renaming and the week number needs changing to the next week's
Step #5: Then the sheet needs renaming and the week number needs changing to the next week's
6
Double-click on "TRU TAC MASTER NEW WK8 MACRO"
Step #6: Double-click on "TRU TAC MASTER NEW WK8 MACRO"
7
Click on "DATA_1"
Step #7: Click on "DATA_1"
8
Click on "Sort & Find &"
Step #8: Click on "Sort & Find &"
9
Click on "Clear"
Step #9: Click on "Clear"
10
Drag here
Step #10: Drag here
11
Drag here
Step #11: Drag here
12
Drag "2 BERNARDO MANTELE GRAHAM"
Step #12: Drag "2 BERNARDO MANTELE GRAHAM"
13
Double-click here
Step #13: Double-click here
14
Drag here
Step #14: Drag here
15
Drag here
Step #15: Drag here
16
Drag "G"
Step #16: Drag "G"
17
Double-click here
Step #17: Double-click here
18
Drag here
Step #18: Drag here
19
Drag "NO"
Step #19: Drag "NO"
20
Drag here
Step #20: Drag here
21
Click here
Step #21: Click here
22
Drag here
Step #22: Drag here
23
Click here
Step #23: Click here
24
Drag here
Step #24: Drag here
25
Click on "PAYE SUMMARY"
Step #25: Click on "PAYE SUMMARY"
26
Click on "Sort &"
Step #26: Click on "Sort &"
27
Drag "00:00"
Step #27: Drag "00:00"
28
Drag "閻"
Step #28: Drag "閻"
29
Click on "00:00"
Step #29: Click on "00:00"
30
Double-click here
Step #30: Double-click here
31
Drag "P. ▼"
Step #31: Drag "P. ▼"
32
Click here
Step #32: Click here
33
Drag here
Step #33: Drag here
34
Click on "100"
Step #34: Click on "100"
35
Drag "Holiday P▾ Night Out"
Step #35: Drag "Holiday P▾ Night Out"
36
Drag here
Step #36: Drag here
37
Double-click here
Step #37: Double-click here
38
Click here
Step #38: Click here
39
Drag here
Step #39: Drag here
40
Click on "topped up by 15.25hrs"
Step #40: Click on "topped up by 15.25hrs"
41
Click on "topped up by 1hr"
Step #41: Click on "topped up by 1hr"
42
Click on "Sage_Upload"
Step #42: Click on "Sage_Upload"
43
Right-click on "191 7215"
Step #43: Right-click on "191 7215"
44
Click on "Delete"
Step #44: Click on "Delete"
45
Right-click on "165 7021"
Step #45: Right-click on "165 7021"