Automatically copy data from one worksheet to another based on cell condition

[ptt87]

Hoping someone can help me solve this one in the simplest method possible. I've read several similar posts, but cannot figure out how to apply them to my spreadsheet (attached).

Referring to the "Participant Data" worksheet and the "Dress Down Sticker" worksheet, what I need to be able to do is link the two worksheets so that if the "Staff Mbr" cell is checked (double-click on the cell) in a given row, the data in the "Last Name", "First Name", and "Pledge" cells of the same row are automatically copied to the next empty row on the "Dress Down Sticker" worksheet.

If possible, I would then like the "Dress Down Sticker" worksheet sorted alphabetically by the last name.

Linking the cells using an IF statement works, except that not every entry on the "Participant Data" worksheet will be a "Staff Mbr," so that method results in blank rows on the "Dress Down Sticker" worksheet.

Thanks. Any help would be greatly appreciated.

[carlito_1985]

Hi,

Give this a bash. I've amended your BeforeDoubleClick event and added comments throughout. The only issue is the checkboxes on the Dress Down Sticker page don't sort. You might need to look at this and possibly changing them to something other than checkboxes.

Let me know if there are any more issues.

Thanks:

Please Login or Register  to view this content.