I'm trying to get the data shown in the mini-sheet into the format of the attached image. Each item (column A) can have many different qty/length (column AO) variations. I want it to paste the size/description (column T) of the product for as many different lengths per item as there are and leave a blank row in between each different item while also sorting with the longest length per item at the top. I will have a different combination of items, lengths, and quantities for every new order, so I'd like to be able to copy and paste the new order/material info into this sheet from the other software and it generates the cut sheet automatically. Any help would be greatly appreciated
| Engineered Wood Cut Sheet.xlsm | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | T | AO | BF | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1 | Item | Item description | Ordered qty | Qty UOM | Price | Size | WO phrase/Tally | Item keywords | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2 | 6516 | I JOIST | 968.0000 | LF | 4.1200 | RFPI-65S 3 1/2"x16" | 4/12', 20/16', 25/24' | 6516 RFPI-65S 3 1/2"x16" I JOIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3 | RL14 | LVL 2.1E | 88.0000 | LF | 7.3900 | 1 3/4" x 14" | 4/10', 4/12' | RL14 1 3/4"x14" LVL 2.1E | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 4 | RL16 | LVL 2.1E | 124.0000 | LF | 8.4400 | 1 3/4" x 16" | 2/12', 2/24', 2/26' | RL16 1 3/4"x16" LVL 2.1E | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 5 | RIM16 | RIMBOARD | 108.0000 | LF | 4.4700 | 1 1/8" x 16" | 9/12' | RIM16 1 1/8"x16" RIMBOARD | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Sheet1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
