C
candybox
I am trying to sort named ranges, and cannot do it. Any help would be great
F
Frank Kabel
Hi
what exactly is not possible? Do you get an error message, etc?
what exactly is not possible? Do you get an error message, etc?
P
Peo Sjoblom
Can you be more specific, what can't you do? Or rather what do you excpect to
happen, what happens and how did you do it?
Regards,
Peo Sjoblom
happen, what happens and how did you do it?
Regards,
Peo Sjoblom
C
candybox
I have data in a bunch of different cells, but it is all attached to one
number, which is listed in column A. I have selected the data and given it a
range name. What I would like to do is sort the named ranges, so that all
the cells in the named range stay together.
number, which is listed in column A. I have selected the data and given it a
range name. What I would like to do is sort the named ranges, so that all
the cells in the named range stay together.
F
Frank Kabel
Hi
does that mean you have for example in A1 a name and in B1:B10 associated
data?. Please try to be a little bit more specific. We don't know your file.
We don't know what a 'bunch of cells ' really is
does that mean you have for example in A1 a name and in B1:B10 associated
data?. Please try to be a little bit more specific. We don't know your file.
We don't know what a 'bunch of cells ' really is
C
candybox
I have a number in A1 name in B1 & C1; list of data in D27; list of data in
E2:E11. Then the same thing starts at A13; B13 & C13 etc.
7; list of data inE2:E11. Then the same thing starts at A13; B13 & C13 etc.
F
Frank Kabel
Hi
now I see. Problem: Excel's sort function can't sort such data setup. It
requires a database table like setup (that is one row per record)
now I see. Problem: Excel's sort function can't sort such data setup. It
requires a database table like setup (that is one row per record)