neilp
Well-known Member
- Joined
- Jul 5, 2004
- Messages
- 529
- Office Version
- 365
- Platform
- Windows
hi
i have 15 rows of data in sheet2 (A2:A16). In the column B2:b16 i have a data validation with a drop down giving the option Yes and No. they are all set as no to begin with.
i would like a way where by, i can change a few of these to yes, then click a button and the code would copy only the data that has a yes in the corresponding column.
this data would then be pasted into sheet1, cells C5:c19, and finally, if any cells remain blank, the whole row on sheet 1 should be deleted.
is this possible?
thanks in advance
neil
i have 15 rows of data in sheet2 (A2:A16). In the column B2:b16 i have a data validation with a drop down giving the option Yes and No. they are all set as no to begin with.
i would like a way where by, i can change a few of these to yes, then click a button and the code would copy only the data that has a yes in the corresponding column.
this data would then be pasted into sheet1, cells C5:c19, and finally, if any cells remain blank, the whole row on sheet 1 should be deleted.
is this possible?
thanks in advance
neil