I am wanting to ensure that specific data is entered into specific fields on specific occasions.
Eg
If Cell A1 entry is "Regal" then cell B1 MUST be either BBB or CCC. Nothing else and it can not be left blank. Any simple ideas ?.
Thanks. I'm having a bad day !
Hi
I have a spreadsheet that is used to capture data on a daily basis, month on month. The data, once captured is then sent out to various parties. Each party has a requirement to see different columns.
The user makes considerable use of the Grouping/Outline functions as each record can have 5...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.