VBA - lookup and replace

[aheverett1]

I'm stuck on a problem in VBA. I need to replace a current light fixture in a cell with another light fixture and then loop to the next cell down and do the same until either a blank cell or the end of my range. The fixture that replaces the current is in a "datasheet" and is in the same row as the current fixture, just a different column. I can currently just do a vlookup and get what the replacement fixture is going to be but i'm not sure how to lookup the current fixture in column A and replace it with the fixture in column G using VBA. The column the replacement fixture is in would be determined by another cell as well.

if this is too vague i am happy to expand more on it.

Thank you in advance.

 

[rpaulson]

if i understand correlty try this on a copy of your file.

Sub do_it()

For r = 2 To 100 'adjust range as needed
Cells(r, "A").Value = Worksheets("Datasheet").Cells(r, "G").Value
Next r

End Sub

hth,
Ross