Add or remove text form a list using click button

Hi all! Having some issues with VBA. Just new to this world and finding my feet.



I have a cell (B32) with some text (actually a date)

I want to add this date to a list - list located from cell B42:B48

Using VBA I would like to do the following (using a click button)

1. Check the list doesn't already have the Date added -
a. If so remove the date
b. If not add the date to the first available row in the list.

Can this be done - 1 click either puts the date into the list or removes it if already there?

I have been using the following to add the date - (Range P56 is just another list I wanted the info added to)

Range("B32").Copy
Range("B48").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Range("P56").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues

End Sub

Hope you guys can help.

Many thanks in advance.

Many thanks for the swift reply

As I say I am not the best at this, just learning. I perhaps can explain myself better

From what you have sent me I can't seem to get the code to work.

I have done as you have suggested and attached a sample workbook.

---------

Some further info -

Sheet : Before - Add Player

Group A - I would like to use a click button to add players to the AVAILABLE list below - B23:B29, and if possible remove the player if I click again on the button assigned to the player --

e.g.

Cell B11 = JOHN.A

Click on button located over the cell B11- Add player to next available cell in the range B23:B29. If player already located in this range then remove player.


I would also like to highlight the cell that the player name is originally located in (e.g. Select JOHN.A - he is added to the AVAILABLE list, highlight cell B11.


I maybe also creating another scenario though -

What if I have selected JOHN.A , JOHN.C and JOHN.G.
These players appear in the Range B23:B29
JOHN.A in B23
JOHN.C in B24
JOHN.C in B25


I decided to remove JOHN.A, will JOHN.C and JOHN.G automatically move up to the the free cell vacated by JOHN.A?

e.g
Click button over JOHN.A (Cell B11) - JOHN.A is removed
JOHN.C in B23
JOHN.C in B24


Also included

Dates - Its the same scenario as the Player Add.



Thanks again. Hope I have better explained this !