Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple task that I want to write a macro for but I can't
seem to make it work. I have two columns (A and B) like this. A B 1 Estimated fall out 2 9000 5885 3 8000 8115 4 6500 8698 I want to compare the value on every row and do different things with each row depending on their relation. IF (A1B1) THEN CUT ENTIRE ROW AND INSERT AT ROW 9 IF (ABS(A1-B1) < 100) THEN DELETE ROW ELSE GOTO NEXT ROW UNTIL BLANK I hope you get the pseudo. I guess a loop would be in order. Something like this perhaps. X=2 Do until Cells(x, 1).Value = "" VBA-CODE.. X=X+1 Loop Would be very grateful for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Macro help? | Excel Discussion (Misc queries) | |||
Help with simple macro | Excel Discussion (Misc queries) | |||
Need Help With A Very Simple Macro | Excel Discussion (Misc queries) | |||
Simple Macro IMO | Excel Programming | |||
Simple Macro Help | Excel Programming |