Excel 2007 : Auto Deleting Cell when a Date is reached

[McFlea]

I'm setting up an excel file to deal with Visa's, i want the cell containing the visa information to auto delete when the visa expires. Contined within the cell i want to delete will be the country the visa is for, type of visa, and most importantly the date the visa expires on, when the date in the cell is reached i want all the information to delete, including the date. If anyone can help that would be brillaint

[pike]

Hi McFlea
Welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!