Hopefully a kind soul will help me out here, so this is what I want to happen -
Lookup cell $H$2 with cell L3 on sheet 2 and find the match on sheet 1 in column E and column A.
When the match is found enter the value from P3 into the corresponding row in column F on sheet 1.
Repeat process for the 6 rows in sheet 2.
Sheet 2 always has a max of 6 rows to search through, sheet 1 has a differing amount of rows each day.
I would take a guess at this needing something like UBound which is something I have no clue about, I usually record a macro and edit it to suit my needs but this is beyond me! If anyone is able to help would
they also be able to pop a few notes in the code to help me understand what the hell is going on!