I am trying to create a navigation tool, part of which is tide calculations
in the channel. There are '12 states of tide' and so I have 12 tide atlases
on 12 sheets.
On these pages are forms for the user to imput tidal data for upto 8 legs of
their
passage. I want to prevent the user inputting tidal data twice into the same
leg so once tidal data has been inputted into one leg in the form on a
particular sheet the programme prevents the user inputting data in a
different sheet for the same leg.
At present I am getting circular references when I use 'what if' scenarios.
Is it possible to have one form copied to each page that will show inputted
data on one sheet on all the rest ?
An alternative might be to have one sheet with one form but to somehow show
the 12 tide atlases one at a time in a window. Can this be done in Excel ?