I have attached an example workbook with 2 examples.
This is how it is intended to work.
If one of the cells in worksheet 'Example' (example 2 for this instance) within an area - for example F5 - is marked with 'N' then on the other sheet 'Front Page UnderCon example 2' that regarding area (area 1 in this example) should be marked as 'Y'.
However, if there is no 'N' stated in the 'example 2' sheet then the flag status (Front page sheet) should be 'N'
Bookmarks