Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move row based on value in cell
Hi All
I have searched and found lots of examples of moving rows based on the values in a cell but I can't get it so that it loops through several named worksheets (there are other unconnected sheets in the book hence naming them). What I am wishing for is code that will examine cells in column Y and if there is a date to move the entire row to a sheet named Archive.The source row is then cleared (not cut as I want to preserve the formatting).. This macro then goes on to other named sheets. If one of you guys can help it is really appreciated. Kind Regards Angelo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I move a cell based on a match of another cell in excel? | Excel Worksheet Functions | |||
Move cells to another column based on value of cell | Excel Programming | |||
Move shape, object, pic to center of new cell based on cell value | Excel Programming | |||
Macro to move cell contents based on formatting | Excel Programming | |||
Excel VBA: Move Userform Based on Active Cell? | Excel Programming |