VBA help

[MissVicki]

I need a macro that checks column C for text that includes "LT" and then when found it takes the date from column H in the row just above it and moves it to the row beneath it (the same row that the "LT" letters were found) I used to be decent at this but its been two years since Ive had to do anything with it and I'm at a loss. It's true if you dont use it you lose it.

[DGagnon]

something like this shoudl work for you, i was unclear if you wanted to clear the value in the row above, so i commented out that line, if thats what you want just uncomment that line.

Sub LT_Search()
    For r = 1 To Range("C1048576").End(xlUp).Row
        If Range("C" & r).Value = "LT" Then
            Range("H" & r).Value = Range("H" & r - 1).Value
            'Range("H" & r -1).value = ""
        End If
    Next
End Sub

[MissVicki]

Thank you! It worked like a charm! You're the best!!

[MissVicki]

Hi,
I didn't ignore the request I simply hadn't had the time to read the rules. I'm very sorry. I understand that ignorance of the rules is no excuse but this is my very first time belonging to something like this. I don't even use Facebook. Please accept my humble apology and kindly delete my account since my "bumbling around" in here is so offensive. Thank you for the opportunity to join, thank you for the advice and again please accept my apology for the screw up(s).

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[MissVicki]

Solved thank you)

[royUK]

You don't have to leave, that's your choice. You agreed to the rules without reading them & get upset because I tell you about it. Feel free not to post if that's your choice, doesn't bother me. You are getting free help.