On Sheet Form Board Tables there is a Terminal Number that is being searched to produce a result in the STX Term #. It is searching the A column on the X Ref Sheet and returning the values to the right of it in Column B. I'm Needing the STX Term # to populate a drop down box with all matching results from the Terminal Number Search.
Workbook???
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
oh right... one sec....
Workbook attached
I was wondering if it was possible to do this using Data Validation??
Last edited by bashscript; 04-14-2021 at 09:40 AM.
im guessing this isnt possible lol!!
There haven’t been many views yet! Be patient - give it at least 24 hours!
Do you think this can be solved using Power Query??
To "Form Board Tables" code module.
Will work when you change any cell in Col.B that have formula in Col.D.
Please Login or Register to view this content.
Not Solved, Closing Thread due to it being obsolete.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks