
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"
