Hi everybody, im looking for a way to simplify this command, i have a list that i wish to check for "T5", and if "T5" is indeed in the list, to check results in the Ranges (AB5+), and if exist then put the data from (AC5+)
Sheets("Mercantil").Select
If Range("T5") = Range("AB5") Then
Range("T5") = Range("AC5")
End If
If Range("T5") = Range("AB6") Then
Range("T5") = Range("AC6")
End If
i mean like this command works and haves been helpfull but im going to add at least 100 more cells of information and i want a way to improve this command
Cant post the worksheet since it was clients and work sensitive information
thanks in advance!!
Bookmarks