ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
1Update new products to be monitored in the Product Masterlist file in column M
3
2Use raw data in Planning numbers SKU, make sure formula in Y reaches the latest row update
4
3Filter new products in column Y
5
4Copy results from columns A - AB, from Start of the year to recent data
6
5Paste in the raw file here
7
6Check #N/As in column AC (Parent Code)
8
Copy Item code and Item description of those with #N/A
9
Paste in Parent Code tab. Column A and B
10
Group similar product variants by assigning a parent code
11
Formula in Raw file column AC should be complete after doint this
12
7In summary tab, a new column should be created when a new new product is added to the monitoring
13
8Copy formula of last column and paste as formula and formatting to the next blank column to read added products
14
9Refresh pivot
15
10In row 48, adjust col_index_number in the formula reference
16
11Adjust store names, agents, groups when necessary or when there are changes
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100