I have a list of numbers on a spreadsheet ie:
A B C D E
1 500 501 502 503 504
2 505 506 507 508 509
3 510 511 512 513 514

I would like to enter a number in a cell and then hit a button to eliminate that number from my list. Is there code I can write to do this??

ie: enter 506 then hit a button and it would remove 506 from the list example

A B C D E
1 500 501 502 503 504
2 505 507 508 509
3 510 511 512 513 514

I have given the list of numbers a defined name as "Numbers"

Anyone that could help, I would greatly appreciate it! Or refer me to a website that may help!

Thank You,
Michael