Spreadsheet: 134513d1325366784-multiple-questions-to-be-asked-on-workbook-set-up-forum-example-revised-1-
Sheet: COVER

JOB# |  |  | JOB NAME |  |  |  |  |  | CONTRACTOR |  |  |  |  |  |  |  |  | forum notes-                                                I wish to have excel automatically open a fresh panel worksheet whenever I enter a new panel in column D (magenta field), and pull the data entered from each respective worksheet and enter it in that sheet's row (green and blue feilds)
CUSTOMER CONTACT INFO |  |  |  |  |  |  |  | ENGINEER CONTACT INFO
 |  |  |  |  |  |  | NAME
 |  |  |  |  |  |  | PHONE
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | FAX
COMMENTS
JOB SUMMARY |  |  |  |  |  |  |  |  | CUBIC YDS |  | LBS |  | TONS |  | MAT. $
 |  |  |  |  |  |  |  |  | 6.231674382716049 |  | 25238.28125 |  | 12.619140625 |  | #N/A
PANEL SUMMARY
STRUCTURE |  |  | PANEL # |  | WIDTH |  | HEIGHT |  | VOLUME |  | LBS |  | TONS |  | MAT. COST
 |  |  |  |  | feet | inches | feet | inches | feet | yards
 |  |  | Panel1 |  | 8 | 9 | 19 | 2.125 | 111.8663194444444 | 4.143197016460905 | 16779.94791666667 |  | 8.389973958333334 |  | 1662.329861111111 | 8
 |  |  | Panel2 |  | 8 | 9 | 9 | 8 | 56.38888888888889 | 2.088477366255144 | 8458.333333333332 |  | 4.229166666666666 |  | 852.3888888888889 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
0 |  |  | 0 |  |  |  |  |  | 0
JOB# |  |  | JOB NAME |  |  |  |  |  | CONTRACTOR
STRUCTURE |  |  | PANEL # |  | WIDTH              feet         inches |  | HEIGHT           feet inches |  | VOLUME           feet        yards |  | LBS |  | TONS |  | MAT. COST
RAW MATERIALS                                                                                                                                               PRICES SHOWN ARE IN NO WAY ACCURATE!!!
ITEM |  |  | $ PER |  | UNIT | ITEM |  |  | $ PER | UNIT | ITEM |  |  | $ PER | UNIT
# 3 REBAR |  |  | 1 |  | ft. | 1/2"X4" COIL LOOP |  |  | 2 | ea. | 5/8" WHEELS |  |  | 3 | ea.
# 4 REBAR |  |  | 1 |  | ft. | 1/2"X6" COIL LOOP |  |  | 2 | ea. | 1" STACK |  |  | 3 | ea.
# 5 REBAR |  |  | 1 |  | ft. | 1/2"X2" COIL BOLT |  |  | 2 | ea. | 1 1/2" STACK |  |  | 3 | ea.
# 6 REBAR |  |  | 1 |  | ft. | BOLT SPLICE-FLAT |  |  | 2 | ea. | 2" STACK |  |  | 3 | ea.
 |  |  |  |  |  | BOLT SPLICE-ANGLE |  |  | 2 | ea. | 2 1/2" STACK |  |  | 3 | ea.
 |  |  |  |  |  |  |  |  |  |  | 3" STACK |  |  | 3 | ea.
 |  |  |  |  |  |  |  |  |  |  | 2" F-CHAIR |  |  | 4 | ea.
 |  |  |  |  |  | 8X8 WELD PLATE |  |  | 5 | ea.
2T X 5 1/2" PINS |  |  | 1 |  | ea. | WELD SPLICE-FLAT |  |  | 5 | ea.
1T X 2 3/8" PINS |  |  | 1 |  | ea. | WELD SPLICE-ANGLE |  |  | 5 | ea. | CONCRETE |  |  | 10 | cu.ft.