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.