May 07 2021 04:55 AM
Hello,
I'm trying to create a worksheet that will auto fill data as I type it , let me explain.
Basically I've imported an access database into a excel worksheet. Inside the same workbook , on a different sheet, Id like to begin typing say "3/8 bolts" and when I hit enter I want it to go look through the data base find "3/8 Bolts" and return the price and a couple other values for me. This would allow me to make quick list with pricing and I wouldn't have to look up the price constantly. It would be nice if it also created a drop down menu so when i started typing "3/8....." a menu would pop up and suggest "Bolt" "nuts" " washers".
Please Help
May 07 2021 06:58 AM
SolutionMay 07 2021 07:28 AM
@mathetes wow, I really appreciate you taking the time to respond.
So yes, it will be changing often as we update prices and products. That is why I have created an access database which we will have on a local server so many users can keep the information up to date.
Attached is the very beginning of what I am striving for . There will be a lot more material but the big thing is no matter what line I begin typing a type of material it finds it and inputs the price and labor units associated with it.
May 07 2021 07:58 AM
May 07 2021 08:37 AM
May 07 2021 05:15 PM
This may not exactly what you had in mind, but it is what I had in mind. It's a set of drop down lists, with the second one dependent on what is selected in the first. This is just an example, and there are some comments in meant to show how it can work. It does need a new version of Excel.
May 07 2021 06:58 AM
Solution