Hi there, I am trying to apply a colur that is contained in one workbook to
another workbook. This would be similar to a legend whereby the colour
format for name a in workbook one shows the same colour format in workbook 2
and then again for name b and name c and so on. The colur changes from name
to name, so it is simply automatically transpoing the info, just not sure how
to