I am trying to figure out a way to tell excel to view my spreadsheet and say that stores a, b, c, d, e, f, g, h, i should be listed as region 1 under the region tab column. Then if the store is not listed, add it to sheet with the store name, store number, region code, and 0 for sales reported. Then if there is a store listed that is not in the macro change the font to red (so I know to add it). And finally sort it by region tab, then store #.
sales.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | RegionTab | STORENUM | STORENAME | Sales | Region | ||
2 | Region1 | A | Jonesy1 | 1 | MD-A1 | ||
3 | Region1 | B | JonesyPlus1 | 3 | MD-A1 | ||
4 | Region1 | C | JonesySuperstore1 | 1 | MD-A1 | ||
5 | Region1 | D | JonesyCaf1 | 2 | MD-A1 | ||
6 | Region1 | E | JonesyBarandGrill1 | 2 | MD-A1 | ||
7 | Region2 | AA | Jonesy2 | 1 | MD-B1 | ||
8 | Region2 | AB | JonesyPlus2 | 1 | MD-B1 | ||
9 | Region2 | AC | JonesySuperstore2 | 1 | MD-B1 | ||
10 | Region2 | AD | JonesyCaf2 | 2 | MD-B1 | ||
11 | Region2 | AE | JonesyBarandGrill2 | 1 | MD-B1 | ||
12 | Region3 | BA | Jonesy3 | 1 | MD-C1 | ||
13 | Region3 | BB | JonesyPlus3 | 2 | MD-C1 | ||
14 | Region3 | BC | JonesySuperstore3 | 2 | MD-C1 | ||
15 | Region3 | BD | JonesyCaf3 | 1 | MD-C1 | ||
16 | Region3 | BE | JonesyBarandGrill3 | 1 | MD-C1 | ||
17 | Region4 | CA | Jonesy4 | 2 | MD-C4 | ||
18 | Region4 | CB | JonesyPlus4 | 1 | MD-C4 | ||
19 | Region4 | CC | JonesySuperstore4 | 1 | MD-C4 | ||
20 | Region4 | CD | JonesyCaf4 | 1 | MD-C4 | ||
21 | Region4 | CE | JonesyBarandGrill4 | 1 | MD-C4 | ||
Sheet1 |