Hi, im looking for some VBA code to be able to take the data in Column A and Paste it in a column, a number of times equal to its value in column B. I need the output to look like the second xl2BB sheet below. It's important that the data goes in order from top to bottom each time it is posted, and that the data in column A only shows up a number of times equal to its value in column B.
Thank you for any help!
Thank you for any help!
Auto200.xlsm | ||||
---|---|---|---|---|
A | B | |||
6 | A | 1 | ||
7 | B | 2 | ||
8 | C | 3 | ||
9 | D | 4 | ||
10 | E | 5 | ||
11 | F | 6 | ||
Variables |
Auto200.xlsm | |||
---|---|---|---|
D | |||
6 | A | ||
7 | B | ||
8 | C | ||
9 | D | ||
10 | E | ||
11 | F | ||
12 | B | ||
13 | C | ||
14 | D | ||
15 | E | ||
16 | F | ||
17 | C | ||
18 | D | ||
19 | E | ||
20 | F | ||
21 | D | ||
22 | E | ||
23 | F | ||
24 | E | ||
25 | F | ||
26 | F | ||
Variables |