Hi,

Am Sun, 27 Mar 2016 19:00:10 +0100 schrieb Victor Delta:

Sorry Claus, I realise I perhaps didn't explain it very well. The
'Copy_Title' (perhaps a misleading name) macro is actually quite complex
as it pulls together data from various different places to form the
title of each category.

can you give an example of the table with the values?
You can pick the values are via Application.VLOOKUP or Application.MATCH
but therefore we need the layout of the data table and the condition to
find the correct title.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional