I have a really hard one here that im sure you lot will find really easy!
I have the following columns:
Sheet 1
column F - Unit No
column G - Street
Sheet 2
Column A - Street
Column B - Unit No
Column C - Unit ID
I need to copy the unit ID's from sheet 2 onto the same row as the street and unit no on sheet 1's column B.
Any ideas on how to do this?
Many thanks.
David.
I have the following columns:
Sheet 1
column F - Unit No
column G - Street
Sheet 2
Column A - Street
Column B - Unit No
Column C - Unit ID
I need to copy the unit ID's from sheet 2 onto the same row as the street and unit no on sheet 1's column B.
Any ideas on how to do this?
Many thanks.
David.