oxfordchump
New Member
- Joined
- Mar 6, 2004
- Messages
- 6
Hello everyone,
I'm a new user of all things computer, so be patient please.
Working with excel200 I have a worksheet that produces a cutting list:
COL A: Item,Jambs,Heads,Cills,Mullions,Rails etc.
COL B: Thickness(mm),57,57,57,69,45 etc.
COL C: Width,79,79,79,79,57 etc.
COL D: Req.,2,1,1,1,2 etc.
COL E: mm,1250,1000,1000,1250,980 etc.
This list is the result of just one style and size of window, similar lists will be produced for different windows all part of the same batch.
Can I get excel to look at all these list and produce a batch cutting list that reads as follows? :
69x79mm:
5@1550
3@1200
7@1050
2@775
etc.
69x 69mm:
4@1200
etc.
57x69mm:
18@1200
etc.
45x57mm
etc.
If anyone can point me in the right direction I'm sure it will save me hours.
Thanks...
Chump
I'm a new user of all things computer, so be patient please.
Working with excel200 I have a worksheet that produces a cutting list:
COL A: Item,Jambs,Heads,Cills,Mullions,Rails etc.
COL B: Thickness(mm),57,57,57,69,45 etc.
COL C: Width,79,79,79,79,57 etc.
COL D: Req.,2,1,1,1,2 etc.
COL E: mm,1250,1000,1000,1250,980 etc.
This list is the result of just one style and size of window, similar lists will be produced for different windows all part of the same batch.
Can I get excel to look at all these list and produce a batch cutting list that reads as follows? :
69x79mm:
5@1550
3@1200
7@1050
2@775
etc.
69x 69mm:
4@1200
etc.
57x69mm:
18@1200
etc.
45x57mm
etc.
If anyone can point me in the right direction I'm sure it will save me hours.
Thanks...
Chump