Move sheet. delete row

[ajw150]

Hi,

I have date in a number of rows. The data relates to whether a policy is valid or expired. If a policy expires, I need the row to remove itself and go onto another sheet.

Please see zip as a guide.

Any help would be appreciated. I have trawled the forums and not been able to piece anything together.

thanks

[Bryan Hessey]

Hi,

I have date in a number of rows. The data relates to whether a policy is valid or expired. If a policy expires, I need the row to remove itself and go onto another sheet.

Please see zip as a guide.

Any help would be appreciated. I have trawled the forums and not been able to piece anything together.

thanks

Hi,

the attached should do that each time you activate the Ctrl/Shift/M shortcut key. Whilst it could be automated (on open book, close book, change etc) I would think that for safety the macro would give you the best chance of avoiding needing to retrieve an item.

Also suggested that you Edit the macro to view the code, and make sure that you understand what it is doing.

hth
---