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

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

Record your actions using the macro recorder and see if it works for you. You
can then attach the macro to a button. If there are any specific questions or
the macro bomb for some reason post your problem and we will look at it.
Everything you want to do is perfectly reasonable and should work out in the
end with a little bit of work.

HTH

"Soth" wrote:

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

Thank you Jim and all...



"Jim Thomlinson" wrote:

Record your actions using the macro recorder and see if it works for you. You
can then attach the macro to a button. If there are any specific questions or
the macro bomb for some reason post your problem and we will look at it.
Everything you want to do is perfectly reasonable and should work out in the
end with a little bit of work.

HTH

"Soth" wrote:

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