Apparently we have a problem with email.  Here is my last email to you:
Mike

           I used a button just for my convenience.  You can run the macro
in several different ways if you don't want a button.  You can click on
Tools - Macro - Macros and click on the macro name and click on OK.  Or you
can set a hot key to run it.  Something like Ctrl-Shift-X.  I don't know how
much you know about these things so just ask

           If you want, you can make the first row higher and move the
button into that row.  To move the button, right-click on the button, then
left-click on the button.  Then move the mouse cursor around on the button
until it changes to a cross.  Then hold the left mouse button down and move
the button.

You said:

Where are the methods/properties of the button?

The button is a Forms button.  This means that the button was created by
clicking on View - Toolbars - Forms, then selecting the button, placing the
button, and assigning the macro to it.  Right-click on the button and select
Format Control.  That shows you everything that you can do with the button.
Not much.

You said:

Clearing column E is what removes the formatting, if I format a totals

cell for currency, right?

"Clearing" in Excel-speak means to erase the contents only.  If you clear
Column E you will clear the contents of all the cells in Column E.  This
will have no effect whatsoever on the formatting currently present in Column
E.

You said:

I don't understand the following from your post. Why/how could there be

an incorrect sheet?

Note, and this is important, this code will operate on the ACTIVE sheet, so

you will need to make sure that you have chosen the right sheet before you

run this code.  I can include an error trap in this code to prevent the code

from running on a wrong sheet, if you wish, but you will first have to tell

me what constitutes a right and wrong sheet.

It is common for people to have more than one sheet in a workbook.  In your
case you would have a sheet like you described and that is the sheet that
you want THIS code to work with.  But you could have some other sheet that
holds some other stuff that you don't want THIS code to mess with.  Remember
that the code is dumb.  I wrote this code to work on the active sheet.  As
such this code will do this and that and move this here and that there and
so forth and so forth ON WHATEVER SHEET IS THE CURRENT ACTIVE SHEET.
Obviously, having some other sheet active and running this code is going to
mess up what is on that sheet.  If you use a button on the sheet to run the
macro, you will always have the proper sheet active when the code runs.  But
if you use some other method of running that macro, then you would have to
take care that the right sheet is active.  As I said before, I can write the
code to check what sheet is active before it changes anything or I can write
the code to work with the proper sheet regardless of what sheet is active at
the time.  To do this, of course,  would have to know how to identify what
is the right sheet and what isn't.  Again, this code is written to work on
the active sheet.  Let me know of any changes you want.

           A good VBA book is "Microsoft Office Excel XXXX Power
Programming With VBA" by John Walkenbach.  The "XXXX" is the most recent
version (year) that the particular book covers.  You want to buy the newest
book available since all the books cover every version up to and including
the year in the title.  I found Amazon.com has the best prices.

           Does the code do what you want on the file I sent you?  If you
want to add/delete columns, do so on the Data sheet of that file and send it
back to me with an explanation of what changes you made/want.  Otto