Thread: row movemwnt
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default row movemwnt

Rows need to move with the sort numerical done in column (D) data is in rows
16-125 columns (A:M) Selecting by excel does not move the row data

"Tom Ogilvy" wrote:

Looks like you did a pretty good job of figuring it out, but if it is any
help, here is the question in Klingon:

ghaH 'oH DuH Daq ghaj [the] [row] [a:m] vIH ghorgh [a] [sort] ghaH ta'pu'
Daq [column] [d]

*bracketed words are the original English [ no klingon equivalent]

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

Make sure you select all the range before you sort--not just the column that
you're sorting by.

Curt wrote:

is it possible to have the row (a:m) move when a sort is done on column (d)
column (d) sorts numerical. Have tried to block and use with selection to no
avail.
Thanks


--

Dave Peterson