I need a macro to copy the contents of a cell down until a none blank cell is met:
Becomes:
Stk 28.02.20 Ap.xlsx | |||
---|---|---|---|
B | |||
5 | PAR-00251912 | ||
6 | |||
7 | |||
8 | |||
9 | |||
10 | |||
11 | |||
12 | |||
13 | |||
14 | PAR-00252030 | ||
15 | |||
16 | |||
17 | |||
18 | |||
19 | PAR-00251983 | ||
20 | |||
21 | |||
22 | |||
23 | |||
24 | |||
25 | |||
26 | |||
27 | |||
28 | |||
29 | PAR-00251982 | ||
Sheet1 |
Becomes:
Stk 28.02.20 Ap.xlsx | ||||
---|---|---|---|---|
A | B | |||
5 | 1 | PAR-00251912 | ||
6 | PAR-00251912 | |||
7 | PAR-00251912 | |||
8 | PAR-00251912 | |||
9 | PAR-00251912 | |||
10 | PAR-00251912 | |||
11 | PAR-00251912 | |||
12 | PAR-00251912 | |||
13 | PAR-00251912 | |||
14 | 28 | PAR-00252030 | ||
15 | PAR-00252030 | |||
16 | PAR-00252030 | |||
17 | PAR-00252030 | |||
18 | PAR-00252030 | |||
19 | 4 | PAR-00251983 | ||
20 | PAR-00251983 | |||
21 | PAR-00251983 | |||
22 | PAR-00251983 | |||
23 | PAR-00251983 | |||
24 | PAR-00251983 | |||
25 | PAR-00251983 | |||
26 | PAR-00251983 | |||
27 | PAR-00251983 | |||
28 | PAR-00251983 | |||
Sheet1 |