It seemed so simple, but I can't remember...I what to take an area of cells
and divide them by one cell and get a percentage
=b3/g2 How do I copy the formula to stay in g2 cell
Debra

What is the shortcut for switching between worksheets in Excel?
Thanks

How do you write into an if function, "= any", for example from b2:b20 I
have a list of numbers, in a2 I would like an if function to do this: if b2
= any of b3:b20 = 1. Has it got something to do with &?
cheers

I am auditing a list of subscribers (for their Dental benefit), and
highlighted (in BOLD text) the ones I need to research. I want to count the
cells with BOLD text in a single column. How do I do this?
I looked (believe me, I looked!) all over Microsoft "Help" and did not find

I am working on an excel spreadsheet that has employee data. Th
employees who are inactive/retired are identified using th
"strikethrough" formatting. Now what I want to do is to enter an "IF
statement to say if cell A1 has "strikethrough" formatting

How do I get datas from ALL of the worksheet within the file into
"master worksheet". REMEMBER ALL WORKSHEETS
In the master worksheet:
Column A = worksheet name (example "Sheet 1")

I am trying to set up a table in the #2 worksheet to get the data fro
the table in the #1 worksheet. I have it set up so that a user wil
enter data into #1 worksheet and it will automatically transfer to #
worksheet.

I'm trying to create an automated way to subtotal.  The following code will
subtotal if I have 3 rows of $ amounts in column D & F.  However in my quote
I may have any number of $ amounts to total from 1 - 100.  How can I make the
string intelligent enough to subtotatl those ...

suppose A1 cell is having no.  = 5
           a2                            = 6
i want to automatically get an image in A3 tht ^ (not this image but an
image of an arrow from clip art positioning upward ) meaning that six is

Thanks

How can open my master template workbook and have the information from 3
separate workbook sheets load into my master workbook.
I have three Reports that I poll everyday with Crystal Reports.  These 3
reports are then exported into excel as 3 separate workbook sheets.

Column1 = Orig Hire Date
Column2 = Recent Hire Date
Column 3 = Seniority Date
Column 4 = Benefit Calc Date

I am looking for a way to change the conditional formatting dependent upon case
i.e.   "T" = white text on royal blue background; however
       "t" = Blue text on a light blue background
I have downloaded CFPlus Extended conditional formatting from

I am trying to make cell I add B, C, D, E, F, G, & H automatically... seems
easy enough but everything I try keeps giving me an error!!
Thanks for your help!!!!

I have a worksheet with the following data in Sheet1
Col A   Col B  Col C
Ram    ABC    Hi-Hi
Ravi     CDE    Med-Med