HI all,
Thanks for allowing me the opportunity to pose a question.
I am trying to streamline my workload a little and need your help.
I have sheet 1 and sheet 2 , both sheets have column D with the same data
except sheet 2 D has more data which means its lines do not lineup with sheet 1.
Also sheet 1 col E is empty, col F is old price.
Sheet 2 col E is the new price, col F is old price.
I want to update sheet 1 col E with sheet 2 col E new price opposite like code's col D.
The problem I am having is, because the codes in sheet 2 are on diff lines the simple (if) statement only works a short way then puts in zero's for the rest because the data on the corresponding lines do not match.
If someone can please help.
Bruce.
Thanks for allowing me the opportunity to pose a question.
I am trying to streamline my workload a little and need your help.
I have sheet 1 and sheet 2 , both sheets have column D with the same data
except sheet 2 D has more data which means its lines do not lineup with sheet 1.
Also sheet 1 col E is empty, col F is old price.
Sheet 2 col E is the new price, col F is old price.
I want to update sheet 1 col E with sheet 2 col E new price opposite like code's col D.
The problem I am having is, because the codes in sheet 2 are on diff lines the simple (if) statement only works a short way then puts in zero's for the rest because the data on the corresponding lines do not match.
If someone can please help.
Bruce.
