I looking to write a vba to enable to following if this is possible?
On each date "07/01/2018" in location A, B or C no more than 4 entries "Bulk" can be entered on the same day - Flag a colour
And on the same day "07/01/2018" in locations A, B C no more than 6 entries "Pallets" can be entered on the same day - Flag a colour
Location A can hold on any one day 4 x Bulk & 6 x Pallets
Location B can hold on any one day 4 x Bulk & 12 pallets
Location C can hold on any one days 4 x Bulk & 6 pallets
In the current sheet there are 29 columns holding data
Bookmarks