Past due dates & move values

August 18, 2011 at 08:30:56
Specs: Windows XP
I have CHECKS,DATE,NAME DESCRIPTION, AMOUNT.
I want to move all the rows that meet the criteria after 190 days from today's date.
How can I do this in excel macro?

See More: Past due dates & move values

Report •

#1
August 18, 2011 at 11:02:01
Do you want someone to write the macro for u? hope not....
Try using the for loop to check each row and move (copy-paste then delete, if required) the row to wherever u want...

Report •

#2
August 22, 2011 at 22:11:50
No I have the macro but it's in a long hard way, I would like to simplify it and it's only for 6 or maybe up to 9 rows.
This is the repetitive code for row 124 but I need it up to row 129 or more:


Sub Past_Due()

'Row 124

If Range("K124").Value < 190 Then
Range("H124").Value = "OK"
End If

If Range("k124").Value = "" Then
Range("h124").Value = ""
End If

If Range("K124").Value > 190 Then
Range("H124").Value = "PAST DUE"
Range("E124").Copy Range("F124")
Range("A124:E124").ClearContents
End If

Thanks


Report •
Related Solutions


Ask Question