Go through the steps with the macro recorder on, you will get a pretty fair
macro from that for this job.

--
HTH

Bob Phillips

"Soth" wrote in message
...
Hi there,

I have an existing worksheet and I normally create a copy of a sheet nd
delete old datas, rename heading and keep an existing formula and
soforth...

What I'd like to do is to assign a macro botton of an existing worksheet,
Press it ! so it would automatically delete datas and rename the sheet.

Is it possible for macro? I'm not sure how to do it.

Your help is appreciated.

Sothea