Without knowing the details (ie, where your date is stored), no one can create a
complete macro for you.

Your best bet is to create it yourself. Turn on macro recording (ToolsMacros),
go through all the steps, stop recording and save your file.

You will then have to edit the macro to have it handle more general situations,
but the grunt work will have been done by Excel.

If you have trouble with specific parts of the macro, post another question.
Keep it as specific as possible.

--
Regards,
Fred


"rod" wrote in message
...
I am wanting to cut out a row based on if a Date is entered in column A
Take that cut row and insert- copy or append into Workbook 2 Sheet1 .

This will save me the trouble of having to do a sort on the list and then
selecting and cutting out rows.
Then I have to resort the list. This is taking me a bit of time after
doing the functions several times a day..

thanks
Rod