Marlett chekboxes - Copying and Deleteing Rows on Another Worksheet

[taibe]

Hi All,

Im trying to create file where the user enter data on one worksheet and if copy (marlett checkbox) is selected, the data is copied to another worksheet. If the Marlett checkbox is unclicked, the data is deleted from the other worksheet.

I have managed to find some vba code online which does this. After some modifying, I managed to get it working marlett checkboxes, copying and deleting, but there is some errors in the deleting part.

When deleteing, the match is the column A which is not unique, it deletes the first row with matching cell,

Can anyone help, so that the match is both columns B & C.

I have attached a macro Excel, sorry not sure of the etiquette, please let me know if I should attach a normal Excel file.

Checkbox Test.xlsm

Many thanks in advance.

Taibe

[JBeaucaire]

Simplest answer... since the only column that appears to have unique values is column B, change your "search" to go by that column instead.

Please Login or Register  to view this content.

[taibe]

Hi JBeaucaire,

Thanks for the quick response.

Using your code, the matching is now in column B, but the possiblity of having the same column B is quite high. Would there be any way for it to match column B and column C then deleting the row?

Thanks

Taibe

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.