I have to copy data from an excel sheet on a website to my excel sheet.  The
company that I get the data from doesn’t separate the DATE from the name of
the data e.g. [ICSC-UBS (FEB 3)] is in one cell.  When I paste the data from
the website my sheet still has info that I pasted ...

I entered rows of data and color coded the text in the rows. How do I sort
the rows  by color

Hi,
I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from
sheet1 into column C (which is a singular cell) into sheet 2
So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values

I just upgraded from Office XP to 2007 and one of my add-ins no longer work.  
it was pcmiler.  when i add it to the excel options it disables my workbook
and says I need a VBA converter.  can you please tell me what i need to do to
make it work again?  Thanks!

I work for an investment management firm and I am having trouble calculating
municipal bond yields with Excel.  My problem is two fold.
The first has to do with the how you write the formula or input the data.  
My traders use the following format:

Is it possible to format a cell where if the cell value is negative then
change the value to zero?
Thanks for your help!

The YIELDDISC Function in EXCEL gives me my expected results.  It is a great
ADD-IN Function.  However, I have been asked to describe the Mathematical
Formulas behind this Function and YIELDDISC is a black box on this issue.
I know that it is based on IRR, but does anyone have a ...

When I click my excel icon the hour glass just sits there for a long time
before the spreadsheet opens.  It didn't do that before.

The attached Excel 2002 workbook contains 2 sheets:
(I'm new here and could not see how to attach the xls file. How do I attach
or can I email to a respondent?)
Master - Is our Master Plant List;

how do i automatically move data to a seperate sheet once a specific cell is
validated?

Afternoon, new to developing so please go gently on the answers.
I have the following macro to create a number of sheets based on a
list, name each sheet as per name on the list and then to copy paste a
template onto each sheet. Sounds so (b)loody simple except for a little

How to convert amount into denominations in excell

I need a formula that allows me to find which numbers in a column make the
one I am looking for.
For example, I am looking for the value 4979,40 in the second column, in
this case is the sum of 4502,45 and 476,95.

Hi, I have an excel worksheet with numerous tabs, is there any way I can move
the tabs into aphabetical order quickly and easily???

I have 2 excell sheets once contains the payments made by my bank basing on
the
cheque no and amount another contains (general ledger / gl)documnet no and
amount.