User Profile
jmaxwell85
Copper Contributor
Joined 12 months ago
User Widgets
Recent Discussions
Re: List help
mathetes Thank You it has been a lot of research in how to use functions in excel. so first off the first sheet labeled Cut List Template that was the original sheet that i created and i did all the math by hand and it was very time consuming this sheet is just to list the the handrail and all the parts that need to be cut as you see Handrail 20871H1 has parts 11, 12, 270. Because this is part of a larger job with more handrails every week i created a the part list tab so i when handrails have the same parts i don't have multiple part number for the same part. The Calculator Sheet is just so i can do the math faster it is essentially self contained as in nothing is pulling data off that sheet that is just where i can input the dimensions from the blueprint and it will give me the correct length that the material has to be cut for example the hard elbow measurement is 1-7/8" that is the amount of material that needs to be cut off from the dimensions on the blueprints this sheet is complete that is why it looks like i spent so much time on it because i wanted this sheet to be able to be used by its self and some of the shop guys use this as well nothing on this sheet needs to be changed i hope that helped to clarify the document some Now what i am trying to do is on the QTY Totals List sheet i would like this sheet to auto populate if possible from the Cut List Template Sheet and all i need is a list with quantity length and cope VLOOKUP is what i used to get the Cut List Template to Auto Populate with most of the information from the Part List Sheet (I know this sounds confusing) But i would like the Qty Totals List Not to have Duplicates EX. Hand Rail 1 and Hand Rail 2 Both Have 3 - part 11 so on the Qty Totals List it should have Part 11 - 6pcs as one entry I think this could be done with VLOOKUP and perhaps a filter or another function Well i hope that clarified the sheets and what i need help with i am happy to answer any questions you might have to further help and thank you for taking the time to help me998Views0likes0CommentsList help
I'm not sure exactly what to call it... just for some background information i work for a construction/Metal Fabrication company i have spent the last 20 years in the shop on the fabrication side of things just last year i moved in to the office in a purchasing position part of my responsibilities is making the material cut lists for all the handrail jobs so with minimal experience with excel i created my cut list with a calculator and a part list sheet the cut list automatically pulls information from the part list my limited knowledge of excel and lots of time spent searching the internet has got me this far ... so what i want to do is add another sheet and in that sheet i want it to auto populate a "list" of parts and quantities and the length and cope information Example: Part # Qty Size Cope 11 16 16" No 12 1 14" C1E important to note that Hand Rail 1 has matching parts on Hand Rail 2 and Hand Rail 3 ...so i would like it to add the quantities together so i get a total number I attached Images of all three sheets i wish i could just attach the actual file but oh well just as a side note i have really enjoyed learning about excel so if you have a solution it would be appreciated if you could explain it so that i might learn something Thank You1.2KViews0likes8Comments
Recent Blog Articles
No content to show