#REF Results

Hi, hope I can explain this. Hopefully the attachment will help.

I have created two sheets. On sheet Names I have created a Macro to run from the button which rotates the names. This works ok. On same sheet I have used Conditional Formatting, this works ok.

On the Master sheet I want the result of the Sort (button and macro on Names sheet) to copy over the details from the Names sheet with the formatting.

When I first set up Master sheet using link = etc it brings the results back ok. But as soon as I use the sort macro, all I get on each cell on Master sheet is #REF.

It frustrating, spend a few hours on it. Anyone out there able to point me in the right direction please

This worked for me when I tried it.
(completely replacing your old code)

Please Login or Register  to view this content.