Hi guys

I have a spreadsheet containing 100 "requests" which can be made by a user

i would like the option for the user to be able to delete a request should they wish it either by deleting a row or clearing the contents

Currently I have a single column which is full of buttons (one for each row)

when i click the button on row 10 I would like row 10 deleted

when i click the button on row 30 i would like row 30 to be deleted etc

is there a way to do this without writing 100 macros which are specific to each line?

I feel buttons are not ideal so maybe there is a better solution out there if anyone has any suggestions

thanks

EDIT:
I have also posted the question here:

http://www.ozgrid.com/forum/showthread.php?t=183857