How do I copy info from one excel spreadsheet column into another using a
formula rather than use copy/paste?  The original spreadsheets are in the
wrong column format and I'm trying to avoid endless copying/pasting.

Hi - I would like the following "Todays date is" & today() to be displayed as
Todays date is 6/13/2007. the today()  resolves to the system number. how can
I write the format in the concatenate function?

I need a formula to rotate information from one cell to another when a new
cell is entered.

Is there something that I can do to the front end of the file w/o using vb
code?

Hi again!
I was wondering how I could take the text "ABCD -Text" (in one cell) and
create a formula in another cell so that only "Text" would show up and not
the "ABCD -".  The problem so far is that the "Text" is not always the same #

Hi, im trying to set up a spread sheet for the tand c dept where i work and
we need a list that when an item is selected from it the cells next to it
should automatically show the part number and the weight of the units, any
ideas?

How do I write a function or macro that will look at what is in a cell,
validate it, if correct delete the row, and if invalid just move down a row
and continue until the end of data in a column?

How do I perform this for a cell?

I need to create a formula that will sum a series of nonadjacent cells, but
will be able to limit how many of the cells to sum based on the index.  For
example, I have a dollar total based on 12 months of data:
cell: J10     O10     T10...

i need to sum values of a specific fill color AND other criteria.  i wrote:
=SUMPRODUCT(--(colorindex(BN3:BN530)=colorindex(C619)),--(B3:B530=B620),--(C3:C530=C620),(BL3:BL530))
but its returning #NAME?
i am replicating this formula from another sheet performing a similar task

Ive been playing around the list command in validation and I was wondering if
there was a way to use ranges from 2 different worksheets to be the source to
select from.  I've tried using the name box command to name the cells and
create a union, and that wont work, and something ...

I have a form button that used to have a Go-To macro connected to it. I've
deleted the macro but the button remains. If I right click on it, it will not
highlight so I can delete it.   Please advise.

I have forgotten how to re-establish the brackets { } at the beginning and
end of a conditional sum formula. They disappear when I modify the formula
and I have forgotten how to re-establish them. Can anyone help me?

Hi - using Excel 2003:
I'm stumped on conditional formatting for a comparing 2 columns of
text values per row.
So ....

I enter:
=ROWS(2:$80)
and copy it down.  I get:
=ROWS(2:$80)