Hello,
I've been working on a new template and excel sheet for the quality inspection of fresh carrots we receive.
Everytime we receive a load, we work on a Excel sheet to fill in our quality inspection. So every load has its own sheet based on a template in the same workbook. The name of the sheet always shows the name of our PO (e.i. 20F204 , 20J204 ) which is entered in cell B12 of our the sheet.
Now I'd like to use these sheets for production planning and quality monitoring. I need to create a separate workbook that pulls info from ALL sheets of our quality inspection workbook in a table/list. The source workbook is on a shared drive on the internal server.
I need to pull the cell data (text & numbers) by position of every sheet in the source workbook and make it a list I can use for reference.
From:
To:
Consolidate doesn't let me import text, and even then I'd have to do every sheet/cell one by one. And would need to add sheets as I go.
Hoping this is clear for someone to provide some help, I've been looking on google and youtube, but nothing points to how to import data from all sheets dynamically per cell position in a simple table.
Thanks
I've been working on a new template and excel sheet for the quality inspection of fresh carrots we receive.
Everytime we receive a load, we work on a Excel sheet to fill in our quality inspection. So every load has its own sheet based on a template in the same workbook. The name of the sheet always shows the name of our PO (e.i. 20F204 , 20J204 ) which is entered in cell B12 of our the sheet.
Now I'd like to use these sheets for production planning and quality monitoring. I need to create a separate workbook that pulls info from ALL sheets of our quality inspection workbook in a table/list. The source workbook is on a shared drive on the internal server.
I need to pull the cell data (text & numbers) by position of every sheet in the source workbook and make it a list I can use for reference.
From:
| SHIPPER REF #: | 21054 | DELIVERY: | 4/16 | QUANTITY: | 28 bins | ||||||
| SAMPLE 1 | SAMPLE 2 | TOTAL | |||||||||
| 25lbs / 11340 grams | 25lbs / 11340 grams | 50lbs / 22680 grams | |||||||||
| Defects No 1 | Defects No 2 and ungraded | Defects No 1 | Defects No 2 and ungraded | Defects No 1 | Defects No 2 & ungraded | Total Defects | |||||
| DEFECT | Weight (gm) | % | Weight (gm) | % | Weight (gm) | % | Weight (gm) | % | % | % | % |
| Curve | 314 | 2.77% | 2 | 0.02% | 314 | 2.77% | 2 | 0.02% | 5.54% | 0.04% | 5.57% |
| Crack/Split | 658 | 5.80% | 0 | 0.00% | 168 | 1.48% | 0.00% | 7.28% | 0.00% | 7.28% | |
| Broken root | 0 | 0.00% | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Insect bite | 0 | 0.00% | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Broken crown | 249 | 2.20% | 0 | 0.00% | 249 | 2.20% | 0.00% | 4.39% | 0.00% | 4.39% | |
| Long stem (1" & +) | 0 | 0.00% | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Sunburn | 0 | 0.00% | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Black | 547 | 4.82% | 0 | 0.00% | 0.00% | 0.00% | 4.82% | 0.00% | 4.82% | ||
| Decay | 857 | 7.56% | 0 | 0.00% | 252 | 2.22% | 0.00% | 9.78% | 0.00% | 9.78% | |
| Size under ¾" | 354 | 3.12% | 0 | 0.00% | 0.00% | 0.00% | 3.12% | 0.00% | 3.12% | ||
| TOTAL | 2979 | 26.27% | 2 | 0.02% | 983 | 8.67% | 2 | 0.02% | 34.94% | 0.04% | 34.97% |
To:
| Shipper ref # | Curve wt | Curve % | Total wt | Total % | Delivery date | |
Consolidate doesn't let me import text, and even then I'd have to do every sheet/cell one by one. And would need to add sheets as I go.
Hoping this is clear for someone to provide some help, I've been looking on google and youtube, but nothing points to how to import data from all sheets dynamically per cell position in a simple table.
Thanks
