Hi,
I tried it back in my original workbook but I want the sheet 2 column F value to run for the whole if the column (as I will be adding more values) it gives me a NA error.
Thanks for all your help.