I renamed the value field names in my pivot table. When I removed certain
columns in the pivot table, then later want to add it, the name is lost along
with the settings (ie. sum, and number with no decimals).  
If possible, how can I make this where anytime I remove and add it ...

I have a large group of cells (48) whose format is text, with data that looks
like a date (1-9-01) but is not actually a date.
When I use the replace function to change -9- to -10- it changes the format
of the cells from text to date. How do I keep the replace function from

A guy from 1997 has the exact same question I do now... hopefully
someone can answer it (because he had no responses back then!)... I am
gonna repost his question:
I am trying to plot a chart containing data similar to that shown

how do I find the location of a particular item in a worksheet?  For example,
if I have a spreadsheet showing the last 30 years of sales production how
could I find the cell location of the highest or lowest figure?

How can I set up data validation so that state abbreviations are entered as
two upper case characters?
I have the abbreviations validated from a list, but it doesn't force all
uppercase.

If I have a column with amounts and I color code these with different
colors...... How do I write a formula to add all the dark greens in one cell
and browns in another, and or yellows in another, etc?

My schedule is broken down into days-
example 6:00 a.m.-2:30p.m. monday thru sunday. Is there a
formula for calculating the total number of hours automatically.

First let me thank all of you that have helped me get this far.
I am calculating payroll for a 2 week period and once 40 hours per week are
hit the column for regular time stops at 40 and the remainder goes into the
overtime column. I made this work but if week one has less than ...

In the first sheet titled "Budget Entry" I have data that starts in row b39
and continues out for several hundred columns.  I need this data in a second
sheet titled Classreport starting in cell C3 and proceeding down the column
for a corresponding number of rows.   Obviously I ...

This has driven me nuts for too long (years). I am tracking lots of textual
data in a spreadsheet. I sort and re-sort constantly. Many of the rows (not
all of them) with lots of text have the text dropping out of sight below the
row. I've tried to fix this with AutoFit but the ...

I have an Excel spreadsheet that has 3 separate worksheets in it.
The documents will all be printed together as one large document and I would
like consecutive page numbering throughout the document.  So far, all I can
get is page 1-3 of the first worksheet, page 1-4 of the second ...

I have a couple of problems.
If I try to copy a formula from one workbook to another new one to use the
formula in the new one it adds the name of the originating spreadsheet as
reference. I have to go through each formula and delete the name reference to

I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the
workdays in-between two dates. It has worked fine, but all of a sudden now it
will not work. I checked the Add-Ins and they are still there. Has anyone ran
across this problem before?

I’m trying  Highlight every other line to be shaded grey, does  anyone now  
formula that will do this all at once?
Octet

Hi Dave,
Sorry to be a pain, but I have one last question.
In the macro you had helped me with, I tried to add an additional "else" in
the event no match is found.  Basically, this program is set-up to look for