Say I have two columns of data.
DISTRICT         STATUS AND DATE
10                    Complete 3-2-2007
10                    

Can you kindly help?
I would like to merge woorkbooks contained in a spreadsheet.
The compare & merge workbook option on my tool bar is in active. Can you
tell me how to activate it?

I have a spreadsheet with that I recorded a macro to copy several adjacent
cell data from the row above it, however, if I try re-using that macro it
uses the cell numbers in the original macro and not the new row I am working
on.  

Good  evening.
I am christopher frm India.
My challenge is :  
For example I have 5 rows and 2 columns as mentioned below and now pls look

Is there an Excel function that can point at a two-dimensional array and
return the location of a targeted text string?
For example, if there is a 4X4 grid of cells which have text in them, I'd
want the formula to return the column and row number within the grid where it

I've got a purchase order (pre Excel 2002) which was designed to assign an
automatic number everytime the template was opened and for ages I have tried
to get it to work again now we are using Excel 2003, but when I try to run
the macro I get a message that reads

Is there a way to arrange worksheets inside a workbook in alphabetical order?

How do I create a macro which does the following:
For each line I highlight insert an new line. then copies the info from a
specific cell below to the new line.
Then use the same macro for different rows?

As the title already suggests we are having problems implementing the
function below.
Have tried it in Excel 2002 and Excel 2003 but always receive an error ("The
formula you typed contains an error) when pasting the formula into a cell.

    i have data in a column that looks like this - mar06-may07. i want to use
"text to column' and separate the two dates. i have formatted both columns
as text so it won't 'interpret' Mar06 as 3-Mar or may07 as 7-may. BUT it
won't stop formatting

I am really stuck on the function statement in column four. I realize it is
not correct as it is written but I simply cannot figure out a way to write it
correctly. Can anyone help?
To explain the table below it is a time line of repairs and stocking levels

I have a series of workbooks which access another workbook to complete data.
Some of this is done with data validation by creating a name linked to the
external data. The rest is done using VLOOKUP based on the entries cells
filled with data validation. This all used to work well ...

Excel 2007
I have multiple conditional formatting schemes set up for worksheet.  When I
paste new data into the sheet, how do I apply the formatting?  It disappears
when I paste and the only way I can apply it is to re-select the ranges.  

What does the green triangle to the top left of a cell mean???
These rows are being imported as blank values when I import this worksheet
into Access.

I can't get the "Find" feature to work for Excel 2007.  I don't have anything
locked, hidden, or protected.  It won't find even the most simple things
(e.g. a cell with "1" in it), and I've tried a variety of settings (even
though most were not necessary).  I opened the same ...