Moving Rows Up - based on contents
 

Hi all -

Great site, first time poster, long time tip and trick gatherer!

I'm having some issues, and wonder if this can be done easily (I'm no
much of a programmer as I've been told :)

I have a spreadsheet with values of C, M, U in various cells. What
would like to do is:

- For each column (2 to N):
- Find the first C and INSERT the entire ROW it resides in, to th
top row (row 2 in this case)
- Find the next C (down the column) and INSERT the entire ROW i
resides in the next row
- Repeat until no more C's in the column

- End when all columns have been evaluated.

Anyone care to share an easy way to do this?

Thanks again, happ new year to all!

Travi

--
AskTravi
-----------------------------------------------------------------------
AskTravis's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=49741