Can I make Excel sorting funcion recognize multiple rows as one record
--
JSolesk
-----------------------------------------------------------------------

Hi,
It's OK to copy the formula from one cell to another one within the
same sheet. How about that to copy the formula from one Excel file to
another one? It seems only the value of that cell will be copied to

I have a problem in Excel - VB programming. For the purpose of Customer
Reporting and information, I've develop a VB module to display customer
information and a link to open an Excel file for detail information.
The excel file contain datasource in other link.. So, How to bypass ...

I'm trying to paste an animated us flag (from yahoo) into an excel report,
but it doesn't remain animated once pasted.  Can you help?

I have some text in cells A2 - A646 as below
Smith, John (LD)
Gummerson, Liz (SDLP)
The lengths of names are variable but first name is always seperated by a

I've got a worksheet which has two validation drop-downs - the secon
feeds off the first using:
=INDIRECT(SUBSTITUTE(A1," ","_"))
Now, this was working fine and dandy. Last night however, a colleagu

As an occasional user of excel ive forgotten more than I can remember
, and therefore need to buy a good big book for reference. I do not
need a curent book because ive only ever been able to use half the
features anyway let alone new ones.

What does $A$1 means
--
cmiaoqi
-----------------------------------------------------------------------

i got this formula
=CONCATENATE(A15,B15,C15)
wheni drag down, the formula does increase to =CONCATENATE(A16,B16,C16
but the result does nt change until i hit "enter" on formula. is there

Is there a limit on number of rows?
I want a spreadsheet that has a row for every day for many years.
That would be thousands of rows.
Is there a limit?

I want to know how to make use of filters, i have a column called age, i want
to filter out to different ages groups, like between 24-34 one and other
45-54. how to do that.

Guys
I'm sure thre is a simple solution to my problem and I would be gratefull if
someone could point me in the right direction.
The macros in the new file will not run if the old file is closed. Their

I am looking for a way to look for a value in a column and after
finding that column, selecting that whole row and copying it. Can
anyone help

Is it possible to use VBA functions in a worksheet?  I'd like to use the Dateadd() function on a
worksheet.
Jeff

I have 2 spread sheets for tracking orders.  The orders are entered on
the first sheet and appear in the second sheet by cell reference
formulas.  Eventually when the order is no longer active, I change the
reference formula to the value of the referenced cell since it will be