Adding Checkboxes automatically value based on index match

[nigelog]

I use these checkboxes to allow user to remove unnecessary customers for reporting. To save time though if they already appear on a list then the checkbox should be automatically "checked"

The macro creates a unique list from a large dataset and then adds a checkbox

Please Login or Register  to view this content.

I have been trying with a helper column linked to the checkbox but the macro just overwrites the helper column

Please Login or Register  to view this content.

I tried an If statement but couldn't phrase the required syntax. Any ideas appreciated

[kev_]

Just wondering why you are using checkboxes at all
- you could use a column instead

In attached workbook click in column B and a cross appears in the cell, if it already contains a cross then it disappears
X = not on report
blank = on report

Is the complication of checkbox maintenance adding any value?

[nigelog]

Hi Kev
that method would work but I want to use the checked items in the following way

1. On first selection the list of customers to be removed from the dataset are first copied to another column "H"

2. That list is used as the key to remove all instances of those customers from the original dataset

3. That list is retained for the next report

4. On subsequent population of the listing in column "A", all customers are matched to the list in column "H" and immediately marked for removal again

5. The list is then manually checked and any additional customers to be removed are re-used to remove data from the original dataset

6. The newly checked items items are added to the list in column "H" for subsequent re-use

I had been thinking along the lines of using the "3 values" of the checkboxes to control these retentions/additions so that the whole list did not have to done manually each time

[xlnitwit]

Best guess without a workbook

Please Login or Register  to view this content.

[nigelog]

Perfect Don, many thanks.

Ill look now at if further checkboxes are "checked" that the customer is added to the list in H