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
2
Copy "TRU TAC MASTER NEW WK MACRO"
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
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"
7
Click on "DATA_1"
8
Click on "Sort & Find &"
9
Click on "Clear"
10
Drag here
11
Drag here
12
Drag "2 BERNARDO MANTELE GRAHAM"
13
Double-click here
14
Drag here
15
Drag here
16
Drag "G"
17
Double-click here
18
Drag here
19
Drag "NO"
20
Drag here
21
Click here
22
Drag here
23
Click here
24
Drag here
25
Click on "PAYE SUMMARY"
26
Click on "Sort &"
27
Drag "00:00"
28
Drag "閻"
29
Click on "00:00"
30
Double-click here
31
Drag "P. ▼"
32
Click here
33
Drag here
34
Click on "100"
35
Drag "Holiday P▾ Night Out"
36
Drag here
37
Double-click here
38
Click here
39
Drag here
40
Click on "topped up by 15.25hrs"
41
Click on "topped up by 1hr"
42
Click on "Sage_Upload"
43
Right-click on "191 7215"
44
Click on "Delete"
45
Right-click on "165 7021"
