4 Identical Tabs with identical Ranges feed into master tab and display all data from each tab/Range

D

djspod

New Member
Joined
Dec 11, 2016
Messages
8
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>
[TABLE="width: 1097"]
<tbody>[TR]
[TD]Site[/TD]
[TD]Supplying Site[/TD]
[TD]Line No[/TD]
[TD]Product Description[/TD]
[TD]Units Short[/TD]
[TD]Reason For Shortage[/TD]
[/TR]
[TR]
[TD]Eastwood[/TD]
[TD]Iceland[/TD]
[TD]618[/TD]
[TD]IC 400G WHITE BLOOMER[/TD]
[TD]7[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Eastwood[/TD]
[TD]Wednesbury[/TD]
[TD]19[/TD]
[TD]400g Crusty White[/TD]
[TD]2[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Eastwood[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]5[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Eastwood[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]690[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Eastwood[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]5[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]25[/TD]
[TD]400g White Farmhouse[/TD]
[TD]9[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Bristol[/TD]
[TD]33[/TD]
[TD]400g Fruit Loaf with Orange[/TD]
[TD]79[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Bristol[/TD]
[TD]34[/TD]
[TD]400g Raisin Loaf with Cinnamon[/TD]
[TD]71[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Burnley[/TD]
[TD]166[/TD]
[TD]4 White Toastie Pockets[/TD]
[TD]7[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]6[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Iceland[/TD]
[TD]646[/TD]
[TD]IC 800G MALTED BLOOMER[/TD]
[TD]6[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]55[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]8[/TD]
[TD]800g Wholemeal Medium[/TD]
[TD]44[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Tuscany[/TD]
[TD]121[/TD]
[TD]8 White Rolls £1 PMP[/TD]
[TD]44[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]4[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]365[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Iceland[/TD]
[TD]647[/TD]
[TD]IC 800G SEEDED BLOOMER[/TD]
[TD]23[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Variety[/TD]
[TD]124[/TD]
[TD]4 Stoneground Wholemeal Batch Rolls[/TD]
[TD]22[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]16[/TD]
[TD]400g Medium White[/TD]
[TD]16[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]2663[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Bolton[/TD]
[TD]70[/TD]
[TD]4 Oven Bottom Muffins[/TD]
[TD]2[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]17[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]49[/TD]
[TD]800g White Farmhouse PMP[/TD]
[TD]112[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]64[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]52[/TD]
[TD]4 Fruited Teacakes[/TD]
[TD]1[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]69[/TD]
[TD]6 Seeded Burger Buns[/TD]
[TD]1[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]1900[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]32[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]3[/TD]
[TD]800g Toastie White[/TD]
[TD]1970[/TD]
[TD]Site Issue[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]25[/TD]
[TD]400g White Farmhouse[/TD]
[TD]43[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Bristol[/TD]
[TD]33[/TD]
[TD]400g Fruit Loaf with Orange[/TD]
[TD]83[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]3897[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Stockton[/TD]
[TD]39[/TD]
[TD]400g WW Malted Danish[/TD]
[TD]40[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]173[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Wednesbury[/TD]
[TD]46[/TD]
[TD]800g Seeded Batch 5 Seeds[/TD]
[TD]39[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]53[/TD]
[TD]400g Wholemeal Medium PMP[/TD]
[TD]4[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Burnley[/TD]
[TD]60[/TD]
[TD]6 Pancakes[/TD]
[TD]33[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]4877[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]1115[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]33[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]185[/TD]
[TD]2 Giant Crumpets[/TD]
[TD]45[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Wednesbury[/TD]
[TD]196[/TD]
[TD]Multi Grain & Seed[/TD]
[TD]1[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]10[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]249[/TD]
[TD]800g Half and Half Toastie[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Iceland[/TD]
[TD]617[/TD]
[TD]IC 400G MALTED BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Nottingham[/TD]
[TD]Iceland[/TD]
[TD]618[/TD]
[TD]IC 400G WHITE BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]258[/TD]
[TD]4 Brioche Buns[/TD]
[TD]5[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]50[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]185[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]2861[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Stockton[/TD]
[TD]34[/TD]
[TD]400g Raisin Loaf with Cinnamon[/TD]
[TD]53[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]607[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]13[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Burnley[/TD]
[TD]166[/TD]
[TD]4 White Toastie Pockets[/TD]
[TD]27[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Burnley[/TD]
[TD]169[/TD]
[TD]4 Brown Toastie Pockets[/TD]
[TD]15[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Wednesbury[/TD]
[TD]229[/TD]
[TD]400g Pulses and Seeds Batch[/TD]
[TD]26[/TD]
[TD]24hr adj refused[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]140[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]196[/TD]
[TD]Multi Grain & Seed[/TD]
[TD]2[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]250[/TD]
[TD]800g Half and Half Medium[/TD]
[TD]270[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Gluten[/TD]
[TD]421[/TD]
[TD]GF 4 Multiseed Thins[/TD]
[TD]67[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]12[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]10[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]3[/TD]
[TD]800g Toastie White[/TD]
[TD]500[/TD]
[TD]Company Cuts[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]4[/TD]
[TD]Quality Issue[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Iceland[/TD]
[TD]615[/TD]
[TD]IC 800G TIGER BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Iceland[/TD]
[TD]644[/TD]
[TD]IC 2PK BAKEWELL MUFFIN[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[/TR]
[TR]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]2[/TD]
[TD]Site Issue[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1525"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
clip_image002.png

<tbody>
</tbody>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Eastwood and Depots Early Morning Report[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Delivering Distribution Excellence Through Engagement Innovation and Continuous Improvement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Warehouse Service Information[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sales Date: 27/06/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Order Fufillment[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Total
Ordered[/TD]
[TD]Total
Picked[/TD]
[TD]Total
Shorts[/TD]
[TD]Order
Percentage[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD="colspan: 2"]20487[/TD]
[TD]19778[/TD]
[TD]709[/TD]
[TD]96.54%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD="colspan: 2"]96119[/TD]
[TD]83721[/TD]
[TD]12398[/TD]
[TD]87.10%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD="colspan: 2"]75717[/TD]
[TD]70866[/TD]
[TD]4851[/TD]
[TD]93.59%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD="colspan: 2"]55241[/TD]
[TD]49730[/TD]
[TD]5511[/TD]
[TD]90.02%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Site[/TD]
[TD]Supplying Site[/TD]
[TD]Line No[/TD]
[TD]Product Description[/TD]
[TD]Units Short[/TD]
[TD]Reason For Shortage[/TD]
[TD][/TD]
[TD]W8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD]Iceland[/TD]
[TD]618[/TD]
[TD]IC 400G WHITE BLOOMER[/TD]
[TD]7[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]24hr adj refused[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD]Wednesbury[/TD]
[TD]19[/TD]
[TD]400g Crusty White[/TD]
[TD]2[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Company Cuts[/TD]
[TD="align: right"]695[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]5[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Short delivered[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]690[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD]Trunking Issue.[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Eastwood[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]5[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD]Quality Issue[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]25[/TD]
[TD]400g White Farmhouse[/TD]
[TD]9[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]Site Issue[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Bristol[/TD]
[TD]33[/TD]
[TD]400g Fruit Loaf with Orange[/TD]
[TD]79[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]W966[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Bristol[/TD]
[TD]34[/TD]
[TD]400g Raisin Loaf with Cinnamon[/TD]
[TD]71[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]24hr adj refused[/TD]
[TD="align: right"]199[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Burnley[/TD]
[TD]166[/TD]
[TD]4 White Toastie Pockets[/TD]
[TD]7[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]Company Cuts[/TD]
[TD="align: right"]10105[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]6[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Short delivered[/TD]
[TD="align: right"]79[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Iceland[/TD]
[TD]646[/TD]
[TD]IC 800G MALTED BLOOMER[/TD]
[TD]6[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD]Trunking Issue.[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]55[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Quality Issue[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]8[/TD]
[TD]800g Wholemeal Medium[/TD]
[TD]44[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Site Issue[/TD]
[TD="align: right"]1970[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Tuscany[/TD]
[TD]121[/TD]
[TD]8 White Rolls £1 PMP[/TD]
[TD]44[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]W976[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]4[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]24hr adj refused[/TD]
[TD="align: right"]374[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]365[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD]Company Cuts[/TD]
[TD="align: right"]4118[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Iceland[/TD]
[TD]647[/TD]
[TD]IC 800G SEEDED BLOOMER[/TD]
[TD]23[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Short delivered[/TD]
[TD="align: right"]341[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Variety[/TD]
[TD]124[/TD]
[TD]4 Stoneground Wholemeal Batch Rolls[/TD]
[TD]22[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]Trunking Issue.[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]16[/TD]
[TD]400g Medium White[/TD]
[TD]16[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]Quality Issue[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]2663[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD]Site Issue[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Bolton[/TD]
[TD]70[/TD]
[TD]4 Oven Bottom Muffins[/TD]
[TD]2[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD]W969[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]17[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]24hr adj refused[/TD]
[TD="align: right"]139[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]49[/TD]
[TD]800g White Farmhouse PMP[/TD]
[TD]112[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Company Cuts[/TD]
[TD="align: right"]3028[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]64[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD]Short delivered[/TD]
[TD="align: right"]2334[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]52[/TD]
[TD]4 Fruited Teacakes[/TD]
[TD]1[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD]Trunking Issue.[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Eastwood[/TD]
[TD]69[/TD]
[TD]6 Seeded Burger Buns[/TD]
[TD]1[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD]Quality Issue[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bicester[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]1900[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD]Site Issue[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]2[/TD]
[TD]800g Wholemeal Toastie[/TD]
[TD]32[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]3[/TD]
[TD]800g Toastie White[/TD]
[TD]1970[/TD]
[TD]Site Issue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]25[/TD]
[TD]400g White Farmhouse[/TD]
[TD]43[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Bristol[/TD]
[TD]33[/TD]
[TD]400g Fruit Loaf with Orange[/TD]
[TD]83[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]3897[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Stockton[/TD]
[TD]39[/TD]
[TD]400g WW Malted Danish[/TD]
[TD]40[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]40[/TD]
[TD]400g WW Danish White[/TD]
[TD]173[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Wednesbury[/TD]
[TD]46[/TD]
[TD]800g Seeded Batch 5 Seeds[/TD]
[TD]39[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]53[/TD]
[TD]400g Wholemeal Medium PMP[/TD]
[TD]4[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Burnley[/TD]
[TD]60[/TD]
[TD]6 Pancakes[/TD]
[TD]33[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]4877[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]1115[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]33[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Enfield[/TD]
[TD]185[/TD]
[TD]2 Giant Crumpets[/TD]
[TD]45[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Wednesbury[/TD]
[TD]196[/TD]
[TD]Multi Grain & Seed[/TD]
[TD]1[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]10[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Tuscany[/TD]
[TD]249[/TD]
[TD]800g Half and Half Toastie[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Iceland[/TD]
[TD]617[/TD]
[TD]IC 400G MALTED BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nottingham[/TD]
[TD]Iceland[/TD]
[TD]618[/TD]
[TD]IC 400G WHITE BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]258[/TD]
[TD]4 Brioche Buns[/TD]
[TD]5[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]50[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]185[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]64[/TD]
[TD]6 Pack Crumpets[/TD]
[TD]2861[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Stockton[/TD]
[TD]34[/TD]
[TD]400g Raisin Loaf with Cinnamon[/TD]
[TD]53[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]105[/TD]
[TD]9 Pack Crumpets[/TD]
[TD]607[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]13[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Burnley[/TD]
[TD]166[/TD]
[TD]4 White Toastie Pockets[/TD]
[TD]27[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Burnley[/TD]
[TD]169[/TD]
[TD]4 Brown Toastie Pockets[/TD]
[TD]15[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Wednesbury[/TD]
[TD]229[/TD]
[TD]400g Pulses and Seeds Batch[/TD]
[TD]26[/TD]
[TD]24hr adj refused[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]140[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]196[/TD]
[TD]Multi Grain & Seed[/TD]
[TD]2[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]250[/TD]
[TD]800g Half and Half Medium[/TD]
[TD]270[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Gluten[/TD]
[TD]421[/TD]
[TD]GF 4 Multiseed Thins[/TD]
[TD]67[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Enfield[/TD]
[TD]36[/TD]
[TD]400g Danish White[/TD]
[TD]12[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Variety[/TD]
[TD]231[/TD]
[TD]6 Plain Thin Bagels PMP[/TD]
[TD]10[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]3[/TD]
[TD]800g Toastie White[/TD]
[TD]500[/TD]
[TD]Company Cuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Tuscany[/TD]
[TD]1[/TD]
[TD]800g Medium White[/TD]
[TD]4[/TD]
[TD]Quality Issue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Iceland[/TD]
[TD]615[/TD]
[TD]IC 800G TIGER BLOOMER[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Iceland[/TD]
[TD]644[/TD]
[TD]IC 2PK BAKEWELL MUFFIN[/TD]
[TD]1[/TD]
[TD]Short delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Thetford[/TD]
[TD]Eastwood[/TD]
[TD]130[/TD]
[TD]8 Half & Half Rolls[/TD]
[TD]2[/TD]
[TD]Site Issue[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited by a moderator:

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
You must log in or register to reply here.

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top