Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if condition true then move a whole row to another sheet
I have an excel workbook which contains 3 worksheets - Order, Pending &
Complete - each sheet is exactly the same layout and header row i would like to automate the following: if on the Order sheet "Complete" is entered in column H then move whole row to end of Complete sheet or if 'Pending' is entered in column H then move whole row to Pending sheet i would be grateful if anyone could help please and would prefer if there wasnt any formulae on the actual sheets as due to the way stuff is entered on the Order sheet any formulae could easily be overwritten thankyou xx Gran2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find first row where condition is true? | Excel Discussion (Misc queries) | |||
TRUE condition??? | Excel Discussion (Misc queries) | |||
if condition is true than send info to another work sheet | Excel Programming | |||
Save If Condition is true | Excel Programming | |||
when condition is true, move row to end of different sheet | Excel Programming |