My only
option has been to do a Find on the sheet for each road
name (eg 'High Street') then select the entire row for
that record, cut, switch to the other sheet and paste it
in.

I could really use a macro that would do this
automatically.

So... just record what you are doing, then have a look at
the code that is generated, and modify to suit.

Start by pressing Tools Macro Record New Macro
do a couple of typical cycles, and then stop the
recording Tools Macro Stop recording

Press Alt F11 and go to the appropriate Module.


RClay AT haswell DOT com