Hi folks
I am looking for VBA code to copy data to another worksheet
what I am trying to do is have a macro that will copy rows in sheet1 to sheet2 if column C has a value then copy the next row if it has data, if the next row is blank it will look for the next row which column C has a value and copy that to a sheet2
SHEET1
A B C
1 2.00
2 Hat
3
4 data
5
6
7 5.00
8 Glove
9 Hat
SHEET2
A B C
1 2.00
2 Hat
3 5.00
4 Glove
5 Hat
I am looking for VBA code to copy data to another worksheet
what I am trying to do is have a macro that will copy rows in sheet1 to sheet2 if column C has a value then copy the next row if it has data, if the next row is blank it will look for the next row which column C has a value and copy that to a sheet2
SHEET1
A B C
1 2.00
2 Hat
3
4 data
5
6
7 5.00
8 Glove
9 Hat
SHEET2
A B C
1 2.00
2 Hat
3 5.00
4 Glove
5 Hat