Re: Auto populating drop down lists/cells based on conditions
OK - give me a few moments and I'll post a sample file here.
Re: Auto populating drop down lists/cells based on conditions
OK - give me a few moments and I'll post a sample file here.
Re: Auto populating drop down lists/cells based on conditions
Right - give this a go. You must not override anything in columns F, G or H - I would suggest you protect these.
Example tab 4 - start with a choice at the top of column E and the formulae do the rest. Anything you wish to override is added in E. The extra benefit is you can see at a glance which rows have had overrides applied.
Re: Auto populating drop down lists/cells based on conditions
Let me know how you get on with it, please.
Re: Auto populating drop down lists/cells based on conditions
AliGW you are my hero! It works like a charm!
Thank You
Boycie92
Re: Auto populating drop down lists/cells based on conditions
You're welcome!
Don’t have an account yet? Register yourself now and be a part of our community!