Row Copy
Posted by Tony on September 14, 2000 5:26 PM
This is my second post, maybe this will clear up any confusion.
I've been trying for a while but have not been able to create the next step. Rather new at this and self taught so far.
Where A, B, C, D, E, F, G, H are columns in Row 7
A B C D E
INSPECTION, Primary 600 H
F G
=B10+150 =IF(B10=0," ",E7-B3)
H
=IF(G7=" "," ",IF(G7<0,"OVERDUE",IF(G7<10,"Due",IF(G7<30,"Watch",""))))
How can I get Row 7 to copy to a new sheet when G7<30 and keep the original row height, font, borders etc.
Thanks
Tony
Posted by Tony on September 14, 0100 5:29 PM
WOW that didn't come out right how about just this
=IF(G7=" "," ",IF(G7<0,"OVERDUE",IF(G7<10,"Due",IF(G7<30,"Watch",""))))
Posted by Celia on September 14, 0100 6:38 PM
Tony
Put the following formula in the new sheet in the first cell(Column A) of the row of your choice and fill it across the columns :-
=IF(Sheet1!$G$7<30,Sheet1!A$7,"")
Celia
