Hi Guys,

I am running a macro that needs sheet1 to be active. During execution the macro populates a variable called "NAME", name=Joe Bloggs

What I would like is to look in Sheet2 across row 2 until it finds "NAME" (Joe Bloggs) when it finds it, populate a variable called "YearEndFigures" with the value of the last cell in that column.

The wall I have been banging my head against now needs repairs

TIA
Keith