Help with automatic "Cut & Paste"

[Gustavo Strabeli]

Hi!
Need help on this...
I have a workbook with 2 sheets, one named "Effective" and other "Expired".
As the name itself, "Effective" has all contracts we have and which are
effective. When it expires, we have to manually cut from "Effective" and
paste on "Expired".
Is there any UDF I can insert to automatically cut all expired contracts and
move to the other sheet?

Thanks beforehand,
Gustavo.

 

[Paul Lautman]

No, a UDF cannot perform cut and paste.

You will need a macro.

I would use the auto-filter function to list all the expired contracts and
then cutting and pasting them is simple.

 

[Gustavo Strabeli]

Thanks, Paul!
I'd lyke to avoid working manually, but...that's the way!
Thanks again.


No, a UDF cannot perform cut and paste.

You will need a macro.

I would use the auto-filter function to list all the expired contracts and
then cutting and pasting them is simple.