I am creating a worksheet that is used by other users. New data is entered
on a weekly basis. This worksheet contains formulas. When the other users
delete the old data to enter the new data, they delete the formula aswell. I
would like to add a 'Clear Page' button so the formulas will not be deleted.
Could someone please help me with this.

Thank you!

You can record a macro and do the cleanup... then assign the macro to a
button through Tools|Customize|toolbar|New

"TammyMarie" wrote:

I am creating a worksheet that is used by other users. New data is entered
on a weekly basis. This worksheet contains formulas. When the other users
delete the old data to enter the new data, they delete the formula aswell. I
would like to add a 'Clear Page' button so the formulas will not be deleted.
Could someone please help me with this.

Thank you!

You can use WEEKNUM function to get the week number and then create
PIVOTTABTLE.

It takes two parameters, one is a date (or a reference to a cell with the
date) and one is an offset for what day the week should start on [1 for for
Sunday and 2 for Monday respectively.] Heres what the function may look
like on your spreadsheet:

=WEEKNUM(A2,1)

It is part of "Analysis Toolpak'

To enable it
Under the €œTools€� menu, select €œAdd-Ins€¦€�
Under the resulting pop-up dialog, check the €œAnalysis ToolPak€� and press
€œOK€�.

"TammyMarie" wrote:

I am creating a worksheet that is used by other users. New data is entered
on a weekly basis. This worksheet contains formulas. When the other users
delete the old data to enter the new data, they delete the formula aswell. I
would like to add a 'Clear Page' button so the formulas will not be deleted.
Could someone please help me with this.

Thank you!

You may be better off creating a Template.

Users would open a workbook based on that Template and save as a new name.

The Template itself never gets changed and remains as is for next user.


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 19:33:00 -0700, TammyMarie
wrote:

I am creating a worksheet that is used by other users. New data is entered
on a weekly basis. This worksheet contains formulas. When the other users
delete the old data to enter the new data, they delete the formula aswell. I
would like to add a 'Clear Page' button so the formulas will not be deleted.
Could someone please help me with this.

Thank you!