I have certain cells in a worksheet that contain the word YES.  I would like
to replace the word YES with a check mark.

I have a report coming in the form of a csv file, one of the columns has a
list of values which I need to cross reference against another column of
values in a different worksheet and replace with the second value in the
first worksheet. Is it possible to automate this process ...

i have been trying some samples with this:
http://www.contextures.com/xlUserForm01.html
and modified to this:
Option Explicit

I have a team of 10 people who work on 1 single work book, all of them
have a seperate sheet for thenselves, what i do manually at this point
in time is as and when required i cut+paste case number  and details
on the same line from the main sheet to the individual sheet. i would

pls give me answer of this quetion.
a             b          c
1000 -   200     A-b+4%add

I am working on reviewing 2000 projects across the globe. I would like rank
the projects based on type & source (Internal and External)
A    B    C    D    E
Project    Type    Source    Saving    Rank

Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For
example:
Original    New

I have about 50 worksheets in one workbook.  I’ve created a “homepage” that
has a drop-down list.  In the drop-down list are values that represent each
of the 50 worksheets.  I’d like to create a module/function that will take me
to the appropriate worksheet when its worksheet ...

My field list has disappeared.  Usually when you select your pivot table,
your field list appears, and you can drag and drop from there.  My field list
has disappeared.  I have tried going to the pivot table tool bar and choosing
"show field list", but it still does not show.  I ...

Can anyone personally recommend a good approach at forecasting in Excel
(either using inherent features or a third-party application). Thanks.

I hid the subtotals for a field in an Excel pivot table.
I am discovering that there is no unhide option.
How do I bring back the subtotals?
I do not want to regenerate the pivot, I am afraid to mess up the

Hi, I've got a spreadsheet with 20+ tabs that need to be frequently
referenced, and scrolling left and right to find them is a pain.  It
would be nice if there were a way to have the tabs stack on the left
or right of the document.  It would take up more screen space, but be

I have a speadsheet that I enter the Date of Hire of an employee. I would
like to have a formula that will calculate in a cell when someone would be
with the company for 4 months.
for example

Is there a way to have more than 256 text characters per cell?  I'm
writing a macro that uses the characters object, and that works with
strings that are shorter than 256 characters.  Every time I have more
than 256 characters, I get a run-time error.  It says "Runtime Error

I want to make a cell only validate an entry if another cell equals a value.  
I'm using DATA>VALIDATION and selecting CUSTOM.  This is my formula:
=IF(NOT(C5="R"),"X","")
I want this cell to recognize if Cell C5 contains ONLY the letter "R" it is