I've got a macro that re-organises a collection of data I receive at work every day. Its quite long and sometimes we only need 1 or 2 rows from one bit of it.

Basically... There is a fund manager that we use at work and sometimes we have to apply certain rates to some of their funds. If we dont have to for that day, I want to be able to get the macro to delete that chunk from the spreadsheet.

So, can I have a pop up box that says something like "Are there any *name* dilution levies today?" and if it says no, I want it to run a separate macro that searches for that name and deletes all those rows? If the user says yes, I just want the macro to continue on its way doing what it it does.

Any ideas?