VBA Help Needed

[RedHelp]

Hi
Please I need some expert help

I have 2 sheets Sheet1 and Sheet2
I need to copy the value of a cell in Column E and have it paste into a data filter in Sheet 2 cell A5
It then needs to copy whatever the returned value in column B and whatever the row is dependent on where the value was (it will always return one result to copy)
This copied value then needs to be placed Back into Sheet1 Column L for the corresponding row where the Column E value was copied.
Finally it needs to repeat this for all rows in Sheet 1

 

[hnsd24_CN]

it will always return one result to copy?
Is the result in sheet2 B5?I don't quite understand what you said“whatever the row is dependent on where the value was”