Hi,
I have an Excel report, 7 Tabs, 1 for each day of the week.
4 Separate sites fill out this report each morning.
All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared
I purposely refrained from sharing the workbook to avoid each site over typing over another users Row data at the same time, this was way was more manageable, 1 site completes, comes out and the next and so on, the last Site to complete emails the report out.
We are now moving this file to Excel Online in SharePoint, this will allow all users to edit the file at once which is not ideal. (For the reasons above)
My thinking is to:
Rebuild the report, a separate tab for each Sites shortages (Different Range of Rows each day depending on how many Shortages they might have - Dynamic)
Is it possible to have all 4 Tabs Ranges feeding through to One master tab to achieve the same format as the screenshot? (As a workaround)
Can anyone provide any pointers please?
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I have an Excel report, 7 Tabs, 1 for each day of the week.
4 Separate sites fill out this report each morning.
All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared
I purposely refrained from sharing the workbook to avoid each site over typing over another users Row data at the same time, this was way was more manageable, 1 site completes, comes out and the next and so on, the last Site to complete emails the report out.
We are now moving this file to Excel Online in SharePoint, this will allow all users to edit the file at once which is not ideal. (For the reasons above)
My thinking is to:
Rebuild the report, a separate tab for each Sites shortages (Different Range of Rows each day depending on how many Shortages they might have - Dynamic)
Is it possible to have all 4 Tabs Ranges feeding through to One master tab to achieve the same format as the screenshot? (As a workaround)
Can anyone provide any pointers please?
<tbody>
</tbody>
| Site | Supplying Site | Line No | Product Description | Units Short | Reason For Shortage |
| Eastwood | Iceland | 618 | IC 400G WHITE BLOOMER | 7 | Short delivered |
| Eastwood | Wednesbury | 19 | 400g Crusty White | 2 | Short delivered |
| Eastwood | Tuscany | 2 | 800g Wholemeal Toastie | 5 | Short delivered |
| Eastwood | Enfield | 36 | 400g Danish White | 690 | Company Cuts |
| Eastwood | Enfield | 40 | 400g WW Danish White | 5 | Company Cuts |
| Bicester | Enfield | 25 | 400g White Farmhouse | 9 | 24hr adj refused |
| Bicester | Bristol | 33 | 400g Fruit Loaf with Orange | 79 | Short delivered |
| Bicester | Bristol | 34 | 400g Raisin Loaf with Cinnamon | 71 | Short delivered |
| Bicester | Burnley | 166 | 4 White Toastie Pockets | 7 | 24hr adj refused |
| Bicester | Variety | 231 | 6 Plain Thin Bagels PMP | 6 | Short delivered |
| Bicester | Iceland | 646 | IC 800G MALTED BLOOMER | 6 | Quality Issue |
| Bicester | Enfield | 40 | 400g WW Danish White | 55 | Short delivered |
| Bicester | Enfield | 8 | 800g Wholemeal Medium | 44 | Short delivered |
| Bicester | Tuscany | 121 | 8 White Rolls £1 PMP | 44 | Short delivered |
| Bicester | Tuscany | 2 | 800g Wholemeal Toastie | 4 | 24hr adj refused |
| Bicester | Eastwood | 105 | 9 Pack Crumpets | 365 | Company Cuts |
| Bicester | Iceland | 647 | IC 800G SEEDED BLOOMER | 23 | Short delivered |
| Bicester | Variety | 124 | 4 Stoneground Wholemeal Batch Rolls | 22 | 24hr adj refused |
| Bicester | Enfield | 16 | 400g Medium White | 16 | 24hr adj refused |
| Bicester | Eastwood | 64 | 6 Pack Crumpets | 2663 | Company Cuts |
| Bicester | Bolton | 70 | 4 Oven Bottom Muffins | 2 | Quality Issue |
| Bicester | Eastwood | 130 | 8 Half & Half Rolls | 17 | 24hr adj refused |
| Bicester | Enfield | 49 | 800g White Farmhouse PMP | 112 | Short delivered |
| Bicester | Enfield | 36 | 400g Danish White | 64 | 24hr adj refused |
| Bicester | Enfield | 52 | 4 Fruited Teacakes | 1 | Quality Issue |
| Bicester | Eastwood | 69 | 6 Seeded Burger Buns | 1 | Quality Issue |
| Bicester | Enfield | 36 | 400g Danish White | 1900 | Short delivered |
| Nottingham | Tuscany | 2 | 800g Wholemeal Toastie | 32 | 24hr adj refused |
| Nottingham | Eastwood | 3 | 800g Toastie White | 1970 | Site Issue |
| Nottingham | Enfield | 25 | 400g White Farmhouse | 43 | 24hr adj refused |
| Nottingham | Bristol | 33 | 400g Fruit Loaf with Orange | 83 | 24hr adj refused |
| Nottingham | Enfield | 36 | 400g Danish White | 3897 | Company Cuts |
| Nottingham | Stockton | 39 | 400g WW Malted Danish | 40 | 24hr adj refused |
| Nottingham | Enfield | 40 | 400g WW Danish White | 173 | Company Cuts |
| Nottingham | Wednesbury | 46 | 800g Seeded Batch 5 Seeds | 39 | Short delivered |
| Nottingham | Tuscany | 53 | 400g Wholemeal Medium PMP | 4 | Short delivered |
| Nottingham | Burnley | 60 | 6 Pancakes | 33 | Short delivered |
| Nottingham | Eastwood | 64 | 6 Pack Crumpets | 4877 | Company Cuts |
| Nottingham | Eastwood | 105 | 9 Pack Crumpets | 1115 | Company Cuts |
| Nottingham | Eastwood | 130 | 8 Half & Half Rolls | 33 | Company Cuts |
| Nottingham | Enfield | 185 | 2 Giant Crumpets | 45 | Quality Issue |
| Nottingham | Wednesbury | 196 | Multi Grain & Seed | 1 | 24hr adj refused |
| Nottingham | Variety | 231 | 6 Plain Thin Bagels PMP | 10 | Company Cuts |
| Nottingham | Tuscany | 249 | 800g Half and Half Toastie | 1 | Short delivered |
| Nottingham | Iceland | 617 | IC 400G MALTED BLOOMER | 1 | Short delivered |
| Nottingham | Iceland | 618 | IC 400G WHITE BLOOMER | 1 | Short delivered |
| Thetford | Enfield | 258 | 4 Brioche Buns | 5 | 24hr adj refused |
| Thetford | Enfield | 36 | 400g Danish White | 50 | 24hr adj refused |
| Thetford | Tuscany | 1 | 800g Medium White | 185 | 24hr adj refused |
| Thetford | Eastwood | 64 | 6 Pack Crumpets | 2861 | Company Cuts |
| Thetford | Stockton | 34 | 400g Raisin Loaf with Cinnamon | 53 | 24hr adj refused |
| Thetford | Eastwood | 105 | 9 Pack Crumpets | 607 | Company Cuts |
| Thetford | Eastwood | 130 | 8 Half & Half Rolls | 13 | 24hr adj refused |
| Thetford | Burnley | 166 | 4 White Toastie Pockets | 27 | 24hr adj refused |
| Thetford | Burnley | 169 | 4 Brown Toastie Pockets | 15 | 24hr adj refused |
| Thetford | Wednesbury | 229 | 400g Pulses and Seeds Batch | 26 | 24hr adj refused |
| Thetford | Tuscany | 1 | 800g Medium White | 140 | Company Cuts |
| Thetford | Enfield | 196 | Multi Grain & Seed | 2 | Short delivered |
| Thetford | Enfield | 250 | 800g Half and Half Medium | 270 | Short delivered |
| Thetford | Gluten | 421 | GF 4 Multiseed Thins | 67 | Short delivered |
| Thetford | Enfield | 36 | 400g Danish White | 12 | Quality Issue |
| Thetford | Variety | 231 | 6 Plain Thin Bagels PMP | 10 | Company Cuts |
| Thetford | Tuscany | 3 | 800g Toastie White | 500 | Company Cuts |
| Thetford | Tuscany | 1 | 800g Medium White | 4 | Quality Issue |
| Thetford | Iceland | 615 | IC 800G TIGER BLOOMER | 1 | Short delivered |
| Thetford | Iceland | 644 | IC 2PK BAKEWELL MUFFIN | 1 | Short delivered |
| Thetford | Eastwood | 130 | 8 Half & Half Rolls | 2 | Site Issue |
<tbody>
</tbody>
<tbody> </tbody> | ||||||||||||||||||||
| Eastwood and Depots Early Morning Report | ||||||||||||||||||||
| Delivering Distribution Excellence Through Engagement Innovation and Continuous Improvement | ||||||||||||||||||||
| Warehouse Service Information | ||||||||||||||||||||
| Sales Date: 27/06/2018 | ||||||||||||||||||||
| Order Fufillment | ||||||||||||||||||||
| Total Ordered | Total Picked | Total Shorts | Order Percentage | |||||||||||||||||
| Eastwood | 20487 | 19778 | 709 | 96.54% | ||||||||||||||||
| Nottingham | 96119 | 83721 | 12398 | 87.10% | ||||||||||||||||
| Thetford | 75717 | 70866 | 4851 | 93.59% | ||||||||||||||||
| Bicester | 55241 | 49730 | 5511 | 90.02% | ||||||||||||||||
| Site | Supplying Site | Line No | Product Description | Units Short | Reason For Shortage | W8 | ||||||||||||||
| Eastwood | Iceland | 618 | IC 400G WHITE BLOOMER | 7 | Short delivered | 24hr adj refused | 0 | |||||||||||||
| Eastwood | Wednesbury | 19 | 400g Crusty White | 2 | Short delivered | Company Cuts | 695 | |||||||||||||
| Eastwood | Tuscany | 2 | 800g Wholemeal Toastie | 5 | Short delivered | Short delivered | 14 | |||||||||||||
| Eastwood | Enfield | 36 | 400g Danish White | 690 | Company Cuts | Trunking Issue. | 0 | |||||||||||||
| Eastwood | Enfield | 40 | 400g WW Danish White | 5 | Company Cuts | Quality Issue | 0 | |||||||||||||
| Bicester | Enfield | 25 | 400g White Farmhouse | 9 | 24hr adj refused | Site Issue | 0 | |||||||||||||
| Bicester | Bristol | 33 | 400g Fruit Loaf with Orange | 79 | Short delivered | W966 | 0 | |||||||||||||
| Bicester | Bristol | 34 | 400g Raisin Loaf with Cinnamon | 71 | Short delivered | 24hr adj refused | 199 | |||||||||||||
| Bicester | Burnley | 166 | 4 White Toastie Pockets | 7 | 24hr adj refused | Company Cuts | 10105 | |||||||||||||
| Bicester | Variety | 231 | 6 Plain Thin Bagels PMP | 6 | Short delivered | Short delivered | 79 | |||||||||||||
| Bicester | Iceland | 646 | IC 800G MALTED BLOOMER | 6 | Quality Issue | Trunking Issue. | 0 | |||||||||||||
| Bicester | Enfield | 40 | 400g WW Danish White | 55 | Short delivered | Quality Issue | 45 | |||||||||||||
| Bicester | Enfield | 8 | 800g Wholemeal Medium | 44 | Short delivered | Site Issue | 1970 | |||||||||||||
| Bicester | Tuscany | 121 | 8 White Rolls £1 PMP | 44 | Short delivered | W976 | 0 | |||||||||||||
| Bicester | Tuscany | 2 | 800g Wholemeal Toastie | 4 | 24hr adj refused | 24hr adj refused | 374 | |||||||||||||
| Bicester | Eastwood | 105 | 9 Pack Crumpets | 365 | Company Cuts | Company Cuts | 4118 | |||||||||||||
| Bicester | Iceland | 647 | IC 800G SEEDED BLOOMER | 23 | Short delivered | Short delivered | 341 | |||||||||||||
| Bicester | Variety | 124 | 4 Stoneground Wholemeal Batch Rolls | 22 | 24hr adj refused | Trunking Issue. | 0 | |||||||||||||
| Bicester | Enfield | 16 | 400g Medium White | 16 | 24hr adj refused | Quality Issue | 16 | |||||||||||||
| Bicester | Eastwood | 64 | 6 Pack Crumpets | 2663 | Company Cuts | Site Issue | 2 | |||||||||||||
| Bicester | Bolton | 70 | 4 Oven Bottom Muffins | 2 | Quality Issue | W969 | 0 | |||||||||||||
| Bicester | Eastwood | 130 | 8 Half & Half Rolls | 17 | 24hr adj refused | 24hr adj refused | 139 | |||||||||||||
| Bicester | Enfield | 49 | 800g White Farmhouse PMP | 112 | Short delivered | Company Cuts | 3028 | |||||||||||||
| Bicester | Enfield | 36 | 400g Danish White | 64 | 24hr adj refused | Short delivered | 2334 | |||||||||||||
| Bicester | Enfield | 52 | 4 Fruited Teacakes | 1 | Quality Issue | Trunking Issue. | 0 | |||||||||||||
| Bicester | Eastwood | 69 | 6 Seeded Burger Buns | 1 | Quality Issue | Quality Issue | 10 | |||||||||||||
| Bicester | Enfield | 36 | 400g Danish White | 1900 | Short delivered | Site Issue | 0 | |||||||||||||
| Nottingham | Tuscany | 2 | 800g Wholemeal Toastie | 32 | 24hr adj refused | |||||||||||||||
| Nottingham | Eastwood | 3 | 800g Toastie White | 1970 | Site Issue | |||||||||||||||
| Nottingham | Enfield | 25 | 400g White Farmhouse | 43 | 24hr adj refused | |||||||||||||||
| Nottingham | Bristol | 33 | 400g Fruit Loaf with Orange | 83 | 24hr adj refused | |||||||||||||||
| Nottingham | Enfield | 36 | 400g Danish White | 3897 | Company Cuts | |||||||||||||||
| Nottingham | Stockton | 39 | 400g WW Malted Danish | 40 | 24hr adj refused | |||||||||||||||
| Nottingham | Enfield | 40 | 400g WW Danish White | 173 | Company Cuts | |||||||||||||||
| Nottingham | Wednesbury | 46 | 800g Seeded Batch 5 Seeds | 39 | Short delivered | |||||||||||||||
| Nottingham | Tuscany | 53 | 400g Wholemeal Medium PMP | 4 | Short delivered | |||||||||||||||
| Nottingham | Burnley | 60 | 6 Pancakes | 33 | Short delivered | |||||||||||||||
| Nottingham | Eastwood | 64 | 6 Pack Crumpets | 4877 | Company Cuts | |||||||||||||||
| Nottingham | Eastwood | 105 | 9 Pack Crumpets | 1115 | Company Cuts | |||||||||||||||
| Nottingham | Eastwood | 130 | 8 Half & Half Rolls | 33 | Company Cuts | |||||||||||||||
| Nottingham | Enfield | 185 | 2 Giant Crumpets | 45 | Quality Issue | |||||||||||||||
| Nottingham | Wednesbury | 196 | Multi Grain & Seed | 1 | 24hr adj refused | |||||||||||||||
| Nottingham | Variety | 231 | 6 Plain Thin Bagels PMP | 10 | Company Cuts | |||||||||||||||
| Nottingham | Tuscany | 249 | 800g Half and Half Toastie | 1 | Short delivered | |||||||||||||||
| Nottingham | Iceland | 617 | IC 400G MALTED BLOOMER | 1 | Short delivered | |||||||||||||||
| Nottingham | Iceland | 618 | IC 400G WHITE BLOOMER | 1 | Short delivered | |||||||||||||||
| Thetford | Enfield | 258 | 4 Brioche Buns | 5 | 24hr adj refused | |||||||||||||||
| Thetford | Enfield | 36 | 400g Danish White | 50 | 24hr adj refused | |||||||||||||||
| Thetford | Tuscany | 1 | 800g Medium White | 185 | 24hr adj refused | |||||||||||||||
| Thetford | Eastwood | 64 | 6 Pack Crumpets | 2861 | Company Cuts | |||||||||||||||
| Thetford | Stockton | 34 | 400g Raisin Loaf with Cinnamon | 53 | 24hr adj refused | |||||||||||||||
| Thetford | Eastwood | 105 | 9 Pack Crumpets | 607 | Company Cuts | |||||||||||||||
| Thetford | Eastwood | 130 | 8 Half & Half Rolls | 13 | 24hr adj refused | |||||||||||||||
| Thetford | Burnley | 166 | 4 White Toastie Pockets | 27 | 24hr adj refused | |||||||||||||||
| Thetford | Burnley | 169 | 4 Brown Toastie Pockets | 15 | 24hr adj refused | |||||||||||||||
| Thetford | Wednesbury | 229 | 400g Pulses and Seeds Batch | 26 | 24hr adj refused | |||||||||||||||
| Thetford | Tuscany | 1 | 800g Medium White | 140 | Company Cuts | |||||||||||||||
| Thetford | Enfield | 196 | Multi Grain & Seed | 2 | Short delivered | |||||||||||||||
| Thetford | Enfield | 250 | 800g Half and Half Medium | 270 | Short delivered | |||||||||||||||
| Thetford | Gluten | 421 | GF 4 Multiseed Thins | 67 | Short delivered | |||||||||||||||
| Thetford | Enfield | 36 | 400g Danish White | 12 | Quality Issue | |||||||||||||||
| Thetford | Variety | 231 | 6 Plain Thin Bagels PMP | 10 | Company Cuts | |||||||||||||||
| Thetford | Tuscany | 3 | 800g Toastie White | 500 | Company Cuts | |||||||||||||||
| Thetford | Tuscany | 1 | 800g Medium White | 4 | Quality Issue | |||||||||||||||
| Thetford | Iceland | 615 | IC 800G TIGER BLOOMER | 1 | Short delivered | |||||||||||||||
| Thetford | Iceland | 644 | IC 2PK BAKEWELL MUFFIN | 1 | Short delivered | |||||||||||||||
| Thetford | Eastwood | 130 | 8 Half & Half Rolls | 2 | Site Issue |
<tbody>
</tbody>
Last edited by a moderator:
