looking for VBA solution that changes data

[Dark0Prince]

I have old dates in the E column on my sheet called ClientListings. Then on the next sheet Called GJ_Import I have new dates in the C column.
How could I use VBA to update the old dates on SOME of the clients when there client number matches from the A column on both sheets. I also want it to effect a range of cells in between the words startGJ and endGJ

Example data is linked here: https://1drv.ms/x/s!Ap0t6Fmj7XZehBIhhLAgL58G_cFG

 

[Dark0Prince]

omg deleting everying i just wrong my stupid self was editing wrong document

 

[mse330]

I attempted to apply this to other sections and it didn't work I can't even debug it because I just get a runtime error. Does anything appear wrong to you?

Looks ok to me … It could also be due to merge cells. Try changing the below line & if you could loose the merged cells all together as they don't go well with VBA

'Old line
lRow = Sheets("ClientListings").Range("A:A").Find("endABQ").Row

​
'Updated line
lRow = Sheets("ClientListings").Range("A:B").Find("endABQ").Row
​​

_{^{<strike>
</strike>}}​

 

[Rick Rothstein]

omg deleting everying i just wrong my stupid self was editing wrong document

Does that mean mse330's and my codes worked? If not, do you still have merged cells?

 

[Dark0Prince]

No, I still can't search both A& B columns on the import tab. And I didn't know how to get your code to work with out changing my sheet format