How do i add a function button to a worksheet?

  • Thread starter Thread starter TammyMarie
  • Start date Start date
T

TammyMarie

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
 
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.] Here’s 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â€.
 
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
 
Back
Top