Forum Discussion
Auto fill data from a list of information
Hello I was looking for a bit of help to create a excel document to make my job a little easier when I send parts out to heat treatment. What I am trying to do is I have a list of part numbers which ...
HDFanboy Hi, I have attached a sample file of what I used to use to select data from different Oil Rigs. The drop down list is linked to the rig names on the Rig Data tab, the fairlead offset values are updated from the appropriate rig details (a named range called Rigs). Should be easy to follow and should suit the type of thing you want to do.
I managed to get the document working perfectly the way I wanted. I simply type in the part number and the remaining data is entered automatically which will save me a ton of time each week. Took me a while to work out that I had to use a different formula for each column instead of how I started out selecting multiple columns expecting it to work like that. Thanks so much for the help.
- Thanks so much for your help. I’ll give it a try ASAP.
