I have a multi-page workbook in which the formulas on the last tab drive the
entire series of calculations on the other sheets. I apparently made the
mistake of selecting the entire range of columns and hiding them. I haven't
been able unhide them.

I've used the percentage increase answer provided by GE Gimpsey to calculate
increase in fees for this year. Only problem was that the cells are all
formatted to 2 decimal places but calc'ed on full figure so that once rounded
soem of the figures were incorrect if you worked out ...

Very strange problem...
I type SUMPRODUCT and then hit the "=" to bring up the wizard.  I enter the
parameters and it gives me the correct answer at the bottom of the box.
Then when I hit ok, it gives me 0 in the actual spreadsheet.  I click on the

Question:
Worksheet One has all the data for all the groups.
Worksheet Two through … contains portions of the data in Worksheet One.  The
portions are predefined ranges of values that appear in the Group column in

Good afternoon
I would like to have some idea of the VBA code to compare 2 spreadsheets
"old" and "new" and then dump the differences into a new sheet -may be named:
"changes"- created by the code.

I imported several hundred email addresses into a spreadsheet
from an external source. How do I get them to show up as hyperlinks.
gls858

I have formatted a column to display numbers as percentages. I want 100% to
display as bold, but can't seem to apply the conditional formatting to it.
The formatting works fine with plain text.

Has any one a macro to suppress the blank lines of an Excel sheet
(tab)?
Many thanks in advance,
Jacques

I have a numeric value in a cell that is followed by a space and then three
alphanumeric characters e.g., -24 dBm. How can I delete the alphanumeric
chracters and preserve the nummeric charaters so that I can apply the average
function to the entire column?

Cant seem to find any in my copy of Office 1997..??

I need to link pictures together.
I have linked them as can be seen on this TEST:
http://www.ociw.edu/~ekoch/4star/BOM/TEST.pdf
My problem is that the links are fixed, they are to the first cell in the

I have a user that created an sales order form in excel.  He has an order
number that he must keep a manual record of and often duplicates the order
numbers.
What is the best way to automate this so that each time he opens the

I need to count the number of cells with dates that have been reached (as of
today) and count the number of cells that hold future dates.  For example,
Column "A"  holds all past, present (today) and future dates.  My formula
states =COUNTIF(A2:A17,"<=today's date") to count the ...

if i have stored a figure in one and in other cell i want to get that figure
in words is it possible if yes then how as well as vice versa.