Hi would anyone have a macro that would copy data from
Sheet 1 range C1 to F2000 to next available row on sheet 2 column C
but only if data is entered in the row of to column C
and
Sheet 3 range C1 to F2000 to next available row on sheet 4 column C
but only if data is entered in the row of to column C
So as shown in example, data would stop copying at row 20
Thanks
Sheet 1 range C1 to F2000 to next available row on sheet 2 column C
but only if data is entered in the row of to column C
and
Sheet 3 range C1 to F2000 to next available row on sheet 4 column C
but only if data is entered in the row of to column C
So as shown in example, data would stop copying at row 20
Thanks
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | a1 | b7 | |||||||
2 | a2 | b8 | |||||||
3 | a3 | b9 | |||||||
4 | a4 | b10 | |||||||
5 | a5 | b11 | |||||||
6 | a6 | b12 | |||||||
7 | a7 | b13 | |||||||
8 | a8 | b14 | |||||||
9 | a9 | b15 | |||||||
10 | a10 | b16 | |||||||
11 | a11 | b17 | |||||||
12 | a12 | b18 | |||||||
13 | a13 | b19 | |||||||
14 | a14 | b20 | |||||||
15 | a15 | b21 | |||||||
16 | a16 | b22 | |||||||
17 | a17 | b23 | |||||||
18 | a18 | b24 | |||||||
19 | a19 | b25 | |||||||
20 | b26 | ||||||||
21 | b27 | ||||||||
22 | b28 | ||||||||
23 | b29 | ||||||||
24 | b30 | ||||||||
25 | b31 | ||||||||
26 | b32 | ||||||||
27 | b33 | ||||||||
28 | b34 | ||||||||
29 | b35 | ||||||||
30 | b36 | ||||||||
Sheet1 |