Forms
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 ? |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com