Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Rows to another sheet based on an entry | Excel Worksheet Functions | |||
Moving rows from one sheet to another based on a particular cell v | Excel Discussion (Misc queries) | |||
Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
moving contents of cells based on criteria | Excel Programming | |||
moving rows based on criteria | Excel Programming |