Hi All
I have a new issue that needs help
I have a main summary sheet and 3 team sheets
In colum a on all the sheets there is a unique referance number. This number though is only in order on the Summary sheet, and is split by a referance to the other team sheets
Can I use a VBA version of match and lookup to check each sheet in turn and were it matches the unique number bring back 2 cells (in colums u,v on all the sheets)
I have a new issue that needs help
I have a main summary sheet and 3 team sheets
In colum a on all the sheets there is a unique referance number. This number though is only in order on the Summary sheet, and is split by a referance to the other team sheets
Can I use a VBA version of match and lookup to check each sheet in turn and were it matches the unique number bring back 2 cells (in colums u,v on all the sheets)