abdo meghari
Active Member
- Joined
- Aug 3, 2021
- Messages
- 471
- Office Version
- 2019
hi
can I copy specific columns ? I would copy columns (A,B,C,D) and the last three columns based on headers (ARRIVES,SALES,STOCK) which locates under the month
so the last three columns every month I issued three columns so when copy it depends on headers (ARRIVES,SALES,STOCK) which locates under the month
orginal data in first sheet
result in sheet output
can I copy specific columns ? I would copy columns (A,B,C,D) and the last three columns based on headers (ARRIVES,SALES,STOCK) which locates under the month
so the last three columns every month I issued three columns so when copy it depends on headers (ARRIVES,SALES,STOCK) which locates under the month
orginal data in first sheet
ST1.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Oct | Nov | Dec | ||||||||||||
2 | Category | Size | Pattern | Origin | Arrived | Sales | Stock | Arrived | Sales | Stock | Arrived | Sales | Stock | ||
3 | PSR (LRD) | 175/70R13 | B25 | INDO | 16 | 184 | 5 | 179 | 179 | ||||||
4 | 175/70R13 | EP150 | THI | - | - | - | - | - | - | - | - | - | |||
5 | 185/70R13 | EP150 | INDO | - | - | - | - | - | - | - | - | - | |||
6 | 175/65R14 | EP150 | INDO | - | - | - | - | - | - | - | - | - | |||
7 | 175/70R14 | EP150 | THI | - | - | - | - | - | - | - | - | - | |||
8 | 175/70R14 | MY02 | THI | - | - | 296 | - | 5 | 291 | - | - | 291 | |||
9 | 185/65R14 | TEC | THI | - | - | - | - | - | - | - | - | - | |||
10 | 185/65R14 | EP150 | INDO | - | - | - | - | - | - | - | - | - | |||
11 | 185/65R14 | 150EZ | INDO | ||||||||||||
12 | 185/65R15 | TC10 | INDO | 1 | 0 | - | - | ||||||||
13 | 185/65R15 | T005 | INDO | - | - | - | - | - | - | - | - | - | |||
14 | 185/65R15 | T01 | JAP | ||||||||||||
15 | 185/65R15 | B250 | JAP | ||||||||||||
16 | 195/60R15 | AR20 | INDO | - | - | - | - | - | - | - | - | - | |||
17 | 195/60R15 | EP150 | THI | ||||||||||||
18 | 195/60R15 | T001 | JAP | ||||||||||||
19 | 195/60R15 | 150EZ | THI | ||||||||||||
20 | 195/65R15 | MY02 | THI | 50 | 361 | 361 | 361 | ||||||||
21 | 195/65R15 | EP150 | THI | - | - | - | - | - | - | - | - | - | |||
22 | 195/65R15 | EP150 | JAP | ||||||||||||
23 | 195/65R15 | T001 | JAP | ||||||||||||
24 | 195/55R16 | EP300 | THI | - | - | - | - | - | - | - | - | - | |||
25 | 205/55R16 | RE003 | THI | - | - | - | - | - | - | - | - | - | |||
26 | 205/65R15 | EP150 | INDO | - | - | - | - | - | - | - | - | - | |||
27 | 205/65R15 | MY02 | THI | 8 | 668 | 668 | 668 | ||||||||
28 | 205/65R15 | T01 | JAP | ||||||||||||
29 | FS 205/65R15 | TZ700 | JAP | - | - | - | - | - | - | - | - | - | |||
30 | 215/65R15 | T005 | INDO | - | - | - | - | - | - | - | - | - | |||
31 | 205/70R15 | 694 | JAP | - | 16 | 16 | 16 | ||||||||
32 | 225/75R15C | T697 | INDO | - | - | - | - | - | - | - | - | - | |||
33 | 235/95R15C | D618 | JAP | - | 56 | 56 | 56 | ||||||||
34 | 255/70R15C | D840 | THI | 66 | 1,329 | 1,329 | 285 | 1,614 | |||||||
35 | 205R16C | D840 | THI | ||||||||||||
36 | 205/R16C | D697 | THI | 4 | 293 | 293 | 293 | ||||||||
37 | 205/55R16 | AR20 | INDO | 1 | 0 | - | - | ||||||||
38 | 205/55R16 | G3 | JAP | 4 | 0 | - | - | ||||||||
39 | 205/55R16 | T001 | - | - | 0 | - | - | - | - | ||||||
40 | 205/55R16 | ER300 | POL | ||||||||||||
41 | 205/60R16 | AR20 | INDO | 2 | 0 | - | - | ||||||||
42 | 205/60R16 | T005 | THI | ||||||||||||
43 | 205/60R16 | T001 | JAP | ||||||||||||
44 | 205/65R16 | EP300 | INDO | - | - | - | - | - | - | - | - | ||||
45 | 205/65R16 | EP30Z | INDO | ||||||||||||
46 | 265/70R16 | D840 | THI | - | - | - | - | - | - | - | - | - | |||
47 | 275/70R16 | H005 | THI | - | - | - | - | - | - | - | - | - | |||
48 | 275/70R16 | D694 | JAP | - | - | - | - | - | - | - | - | - | |||
49 | LT285/75R16 | AT001 | JAP | - | - | - | - | - | - | - | - | - | |||
50 | TTL | - | 152 | 3,203 | - | 10 | 3,193 | 285 | - | 3,478 | |||||
51 | PSR (HRD) | 215/45R17 | T001 | JAP | - | - | - | - | - | - | - | - | - | ||
52 | 215/50R17 | EP300 | THI | - | - | - | - | - | - | - | - | - | |||
53 | 215/55R17 | GR90 | INDO | - | - | - | - | - | - | - | - | - | |||
54 | 215/55R17 | T001 | JAP | - | - | - | - | - | - | - | - | - | |||
55 | 215/55R17 | T005 | JAP | ||||||||||||
56 | 275/55R20 | ALENZA | JAP | ||||||||||||
57 | 285/50R20 | DSPORT | |||||||||||||
58 | 275/65R18 | 116H | THI | 0 | - | - | |||||||||
59 | 275/65R18 | AL01 | JAP | ||||||||||||
60 | 285/60R18 | T01 | JAP | ||||||||||||
61 | 285/60R18 | D850 | JAP | - | 66 | 66 | 66 | ||||||||
62 | 245/40R20 | RE050 | JAP | - | 13 | 13 | 13 | ||||||||
63 | 265/50R20 | SPORT | JAP | - | 8 | 8 | 8 | ||||||||
64 | 275/30R20 | RE050 | JAP | - | 2 | 2 | 2 | ||||||||
65 | 275/40R20 | DHP | JAP | ||||||||||||
66 | 275/55R20 | D680 | JAP | - | 16 | 16 | 16 | ||||||||
67 | 285/30R20 | RE0050A | JAP | - | 14 | 14 | 14 | ||||||||
68 | 315/35R20 | SPORT | JAP | - | 3 | 3 | 3 | ||||||||
69 | TTL | - | - | 122 | - | - | 122 | - | - | 122 | |||||
In & Out Balance |
Cell Formulas | ||
---|---|---|
Range | Formula | |
M66:M68,J66:J68,M61:M64,J61:J64,M58,J58,M44,M41,J41,M36:M39,J36:J39,M33:M34,J33:J34,M31,J31,M27,J27,M20,J20,M12,J12,M3:M8,J8,J3:J6 | J3 | =G3+H3-I3 |
G44 | G44 | =E44-F44 |
E50:M50 | E50 | =SUM(E3:E49) |
E69:M69 | E69 | =SUM(E51:E68) |
result in sheet output
ST1.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Dec | ||||||||
2 | Category | Size | Pattern | Origin | Arrived | Sales | Stock | ||
3 | PSR (LRD) | 175/70R13 | B25 | INDO | 179 | ||||
4 | 175/70R13 | EP150 | THI | - | - | - | |||
5 | 185/70R13 | EP150 | INDO | - | - | - | |||
6 | 175/65R14 | EP150 | INDO | - | - | - | |||
7 | 175/70R14 | EP150 | THI | - | - | - | |||
8 | 175/70R14 | MY02 | THI | - | - | 291 | |||
9 | 185/65R14 | TEC | THI | - | - | - | |||
10 | 185/65R14 | EP150 | INDO | - | - | - | |||
11 | 185/65R14 | 150EZ | INDO | - | |||||
12 | 185/65R15 | TC10 | INDO | - | |||||
13 | 185/65R15 | T005 | INDO | - | - | - | |||
14 | 185/65R15 | T01 | JAP | - | |||||
15 | 185/65R15 | B250 | JAP | - | |||||
16 | 195/60R15 | AR20 | INDO | - | - | - | |||
17 | 195/60R15 | EP150 | THI | - | |||||
18 | 195/60R15 | T001 | JAP | - | |||||
19 | 195/60R15 | 150EZ | THI | - | |||||
20 | 195/65R15 | MY02 | THI | 361 | |||||
21 | 195/65R15 | EP150 | THI | - | - | - | |||
22 | 195/65R15 | EP150 | JAP | - | |||||
23 | 195/65R15 | T001 | JAP | - | |||||
24 | 195/55R16 | EP300 | THI | - | - | - | |||
25 | 205/55R16 | RE003 | THI | - | - | - | |||
26 | 205/65R15 | EP150 | INDO | - | - | - | |||
27 | 205/65R15 | MY02 | THI | 668 | |||||
28 | 205/65R15 | T01 | JAP | - | |||||
29 | FS 205/65R15 | TZ700 | JAP | - | - | - | |||
30 | 215/65R15 | T005 | INDO | - | - | - | |||
31 | 205/70R15 | 694 | JAP | 16 | |||||
32 | 225/75R15C | T697 | INDO | - | - | - | |||
33 | 235/95R15C | D618 | JAP | 56 | |||||
34 | 255/70R15C | D840 | THI | 285 | 1,614 | ||||
35 | 205R16C | D840 | THI | ||||||
36 | 205/R16C | D697 | THI | 293 | |||||
37 | 205/55R16 | AR20 | INDO | - | |||||
38 | 205/55R16 | G3 | JAP | - | |||||
39 | 205/55R16 | T001 | - | - | |||||
40 | 205/55R16 | ER300 | POL | - | |||||
41 | 205/60R16 | AR20 | INDO | - | |||||
42 | 205/60R16 | T005 | THI | - | |||||
43 | 205/60R16 | T001 | JAP | - | |||||
44 | 205/65R16 | EP300 | INDO | - | - | ||||
45 | 205/65R16 | EP30Z | INDO | - | |||||
46 | 265/70R16 | D840 | THI | - | - | - | |||
47 | 275/70R16 | H005 | THI | - | - | - | |||
48 | 275/70R16 | D694 | JAP | - | - | - | |||
49 | LT285/75R16 | AT001 | JAP | - | - | - | |||
50 | TTL | 285 | - | 3,478 | |||||
51 | PSR (HRD) | 215/45R17 | T001 | JAP | - | - | - | ||
52 | 215/50R17 | EP300 | THI | - | - | - | |||
53 | 215/55R17 | GR90 | INDO | - | - | - | |||
54 | 215/55R17 | T001 | JAP | - | - | - | |||
55 | 215/55R17 | T005 | JAP | - | |||||
56 | 275/55R20 | ALENZA | JAP | - | |||||
57 | 285/50R20 | DSPORT | - | ||||||
58 | 275/65R18 | 116H | THI | - | |||||
59 | 275/65R18 | AL01 | JAP | - | |||||
60 | 285/60R18 | T01 | JAP | - | |||||
61 | 285/60R18 | D850 | JAP | 66 | |||||
62 | 245/40R20 | RE050 | JAP | 14 | |||||
63 | 265/50R20 | SPORT | JAP | 8 | |||||
64 | 275/30R20 | RE050 | JAP | 2 | |||||
65 | 275/40R20 | DHP | JAP | - | |||||
66 | 275/55R20 | D680 | JAP | 16 | |||||
67 | 285/30R20 | RE0050A | JAP | 14 | |||||
68 | 315/35R20 | SPORT | JAP | 3 | |||||
69 | TTL | - | - | 122 | |||||
output |