Microsoft Office Questions? Ask a IT Expert for Support ASAP
hi, are you there?
have you received my latest reply?
I've followed your advice and the result was not as intended.
I am used to using the "list" option in the validation tab. With "list", when you're filling out the column, you get an arrow on the right side of the column an clicking that arrow you get a list of possible fill outs coming from the validating cells.
By using this "custom" option, no arrow appears, neither any fill out option. And when I type any value in the cells I get a message saying I am trying to use a non valid content.
So what should I do to get that same effect as when I am using the "list"validation option?
on the tab "entries", you'll see the validation clause on column E. You'll see that this column is intented to be validaded agains ranges "ID & subjects".
the point is that I want to fill the ID column with the ID of the respective subject and want that while I am filling out both the ID and respective subject from the validation tab are visible.
In fact, the validation is primarily against the ID range.
Is there a more agile way for us to interact? like skype.
yes, your understanding is correct.
yes, thank you.
Sorry for the mess.
how does it work, will you send me to that site again so that I download the file?
well, this still doesn't solve my need.
I need that when I am filling out the 'SUB_ID' column, the arrow on the right hand side is shown and when I click the arrow, combinations of "id and subject" from the validation tab are visible for me to choose from.
is it possible?
thank you so far.
hi have you got my latest?
with the available information, you did an excellent job, thank you.
No, I don't have ms-access, sorry.
I think we can stop here. Thank you for your time and help. I hope we can interact more in the future.
This experience has been very valid for me.