Forum Discussion
Auto Fill rows
Please see attached.
Yes there is an inventory of parts that they already have ! It's all listed out in the way that they want, but it doesn't have the functionality they want (The auto fill). So how it fits into the bigger process is that when the company is bidding on a job and this spreadsheet will be used to fill in the quantity of the parts required, price etc, so they know what they need and they need a more efficient system of doing this. Most of the people that are filling in the spreadsheet don't know what part # goes with what type of part it is. So the reason for this is so they can say look up the description if they don't know the part number and it will auto fill the part # etc., then they can put the quantity. It's not necessarily project specific, rather more of a template to use for every project that we bid on to make the process easier. I attached an example of a couple of different parts, and their description if that helps! Also thank you so much for taking the time to help me out! I was wandering aimlessly looking for the solution to this. mathetes
Please see attached.
Here is the updated file! Patrick2788
Replying here because I hit the private message limit for the day:
Here is a part number that's a triplicate:
A13MHM-1.5 1" Heavy Duty Single Pin Clamp A13MHM-1.5 1" Heavy Duty Single Pin Clamp A13MHM-1.5 1.5" Heavy Duty Single Pin Clamp If you're to select A13MHM-1.5 then you need a means of having it pick the 1'' or 1.5'' inch as needed. One way to do this is to introduce a 2nd criteria to fetch the correct description as needed. Otherwise, VLOOKUP or INDEX-MATCH would give you the 1'' description.
These are all the repeats:
13MHP-1.5 1" 2 PC. High pressure clamps 13MHP-1.5 1.5" 2 PC. High pressure clamps 13MHP-3 3" 2 PC. High pressure clamps 13MHP-3 3" 2 PC. High pressure clamps 13MHP-4 4" 2 PC. High pressure clamps 13MHP-4 4" 2 PC. High pressure clamps 16AMP-1.5-316 1" T-316 Tri-Clamp solid end cap 16AMP-1.5-316 1.5" T-316 Tri-Clamp solid end cap 38S-L-1.5-304 1.5" T-316 Lap Joint Flange 38S-L-1.5-304 1.5" T-304 Lap Joint Flange 38SL-2.5-304 2.5" T-316 Lap Joint Flange 38SL-2.5-304 2.5" T-304 Lap Joint Flange 38SL-2-304 2" T-316 Lap Joint Flange 38SL-2-304 2" T-304 Lap Joint Flange A13MHM-1.5 1" Heavy Duty Single Pin Clamp A13MHM-1.5 1" Heavy Duty Single Pin Clamp A13MHM-1.5 1.5" Heavy Duty Single Pin Clamp A13MHM-3 3" Heavy Duty Single Pin Clamp A13MHM-3 3" Heavy Duty Single Pin Clamp A13MHM-4 4" Heavy Duty Single Pin Clamp A13MHM-4 4" Heavy Duty Single Pin Clamp It's okay if there are duplicates. The part manager that will be filling in all of the part sheets will know the difference and he can manually enter it in if need be ! Patrick2788
This is perfect! Thank you so much! I am wondering though how I can replicate the Part # column so I can fill in different parts all in the same column, but different rows if that makes sense.
I extended the drop menu and the formulas down. Also, added an error check. If you need more rows you can use the fill handle to apply the formulas and validation down.
Wow thank you so much! That is such a big help. I'm still in the process of learning most of the basics of excel, and I couldn't find any guide on how to do this exactly! If I have any other questions is it okay if I ask?