jmaxwell85
New Member
- Joined
- Jan 26, 2024
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Im 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 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 You
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 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 You
