Forum Discussion
List help
I still have not found a solution
I sent you a link to the file on onedrive
thank you
I just took a look at it. I'm afraid I'm not able to figure out what to make of the various tabs within that workbook, nor how to connect what I see there with what you describe in your initial post.
It's a serious mistake to put so much energy into making a spreadsheet look great before you've gotten it to function as you want it to. As you've done it here, for example, you have set up sections that refer to variations in hard elbow parts (or some such), each much the same thing, but with some differences that lead you to create separate sections.. In general, you'd be better served with a single database of comparable parts, with column entries that take care of differentiating the specific variations that you have handled visually by separating them. Excel is wonderful with functions like XLOOKUP, INDEX and MATCH or FILTER (etc) in extracting data from a single consolidated database. Our human eye thinks it's clearer to separate the subsets, but doing so actually interferes with Excel's abilities.
Anyway, I'd be happy to try to help--you clearly have done some good learning, by the way--but you're going to have to do some more work to orient us to the way your workbook is organized, and specifically where the help is needed.
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 functionWell 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 me