Hi Col,

Many thanks for your reply.

However, I am pretty rubbish at Macros.

How do I create this macro and make a shortcut to run it...?

I've opened Tools --- Macros --- Visual Basic Editor, but I can no
find where to create a shortcut key.

Once this is done, do I select the top row of a member's details, the
run the macro - or do I select all the member's rows and run the macr
- or something else.

Sorry to ask such newbie questions, but I appreciate the help/advice.

Kindest Regards,
Shane :-

--
shaneferguso
-----------------------------------------------------------------------
shaneferguson's Profile: http://www.excelforum.com/member.php...fo&userid=3628
View this thread: http://www.excelforum.com/showthread.php?threadid=56071