Finding Intersection? Possibly?

[ShruggedTundra]

Hi Guys,

looking for a solution to a problem and I'm not even sure I'm searching for the right thing.

Basically I have A spread sheet that I've attached (it's just a snippet the full one contains a full year of days).

What I want to achieve is;


Search range search range A3: NB3 for date In TextBox1<o></o>

Set the activecell as the AM / PM Cell Below date <o></o>

<o> </o>
If Activecell = AM then<o></o>

Search A5:A9 for zone in Textbox 2 <o></o>

Find intersection and activate cell<o></o>

Insert “B” into Activecell <o></o>

<o> </o>

If not AM then <o></o>

Search range B13:NB13 for date <o></o>

Search A15:A19 for Zone <o></o>

Find intersection and activate <o></o>

Insert B into Activecell

I have no code for this right now I'm just starting it out. But the idea is to track if things happened in more than one zone on a partucular day
AM Entries is Cell B2 just for referance.

Thanks you

<v:shapetype id="_x0000_t201" path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <vath o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"> <o:lock shapetype="t" v:ext="edit"> </o:lock></vath></v:stroke></v:shapetype><v:shape style="width: 84pt; height: 22.5pt; margin-top: 4.5pt; margin-left: 3.75pt; position: absolute; z-index: 1; mso-wrap-style: tight;" id="CommandButton1" type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF 90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9 Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/ 8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj 39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA ACEAwijHeCgCAAC/BAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysVMlu2zAQ vRfoPxC821osy7YQOaiVOCgQtEaXc8BQlEVUXEDSqoMi/96hlthwihza6kRqZh7fzHvk1fVRNKhl xnIlcxxNQ4yYpKrkcp/j79+2kyVG1hFZkkZJluMnZvH1+v27K5LtDdE1pwgQpM1IjmvndBYEltZM EDtVmkmIVcoI4mBr9kFpyE9AFk0Qh2EaCMIlXp+gbogj6GD4X0A1iv5gZUFkSyxANjQ7/zNwbOi/ I5NMtndGf9U745nTT+3OIF7mGCYniYAR4WAIDGmwDS6q9ieAY2WEz1dVhY45ThZpPMfoKcfzRTQP eyx2dIhCMArTdBnCQRTi8XK+GBNo/fmNclrfvg0A9HoasDijpjn1zGS74/Sy23jstlBCgD02B+eU jDo1ge69db7UE+/0/JXONrPNJl1N4lmxnSTJ7WyyClerSZGERZput8t0UTz76ijJqBKaOM95sFaU vNJNcGqUVZWbQnYAw+OUjfYCc0Vhby5ktdfm4RjC92CjEIbb6wHUOl1GstB6p6Wn7RdjyzCEe/CW RVIVNZF79sFqRh2IMQCdkjuVXwofG663vGk8oF8PzZhXrfzhnvT93Ch6EEy6/rIY1hAHt9TWXFuM TMbEI4PezMeyo0Iy6wxztPYHVnDwF6DZ9/oSAIbntOxg4v/gQUAeUbSx7o4pgfwC+AGNzhakBVf0 hMaUToGeBQDAqOHHxdXtUoanxr8P5/v1bwAAAP//AwBQSwMEFAAGAAgAAAAhAFNSiWHSAAAAqwEA ACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHOskMFKBDEMhu+C 71Byt5nZg4hsZy8i7FXWBwhtplOcpqWt4r691b04sODFSyAJ+fLx7w+fcVUfXGpIYmDUAygWm1wQ b+D19Hz3AKo2EkdrEjZw5gqH6fZm/8IrtX5Ul5Cr6hSpBpbW8iNitQtHqjpllr6ZU4nUels8ZrJv 5Bl3w3CP5TcDpg1THZ2BcnQ7UKdz7p//Zqd5Dpafkn2PLO3KC2zdizuQiudmQOvL5FJH3V0Br2uM /6kRYo9goxHZBcKf+aiz+G8N3EQ8fQEAAP//AwBQSwMEFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoA AABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3q cbwe704zu7OaGSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVOvCZJG4EozSHeffub9/+9 ebN79dqDiKFDIiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6cSO/a5vvvXcUbPqPJmGMx GYUkIggYxXIDd7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3VKpXWWoRp7G0CR6UZ9Rn8 i5XUBJ+JoWZDUIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmIYangQcermD9vbfPqGt5I FzG1Ym1h3cD8pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8DwL4Pllpdijwbg/VqN+NZ ANnLZd69SrPScPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKbS/hGd6vXazl4A7L41hJ+ cKXdarh4AwoZjQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/VqlyL8H0uBgDQQIYVjZGa J2SKfcjJHo7GgmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXzp+jV8yfHD58dP/zp+NGj 44c/Wl7Owh0cB8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU0MLCF18++e3Zkxdfffr7 d49L4FsCj4vwEY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6wFtzzMpwXeI6766A5lEG vD677+g6DMVM0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBMdg/HTmj7swS6ZpaUju97 IXHU3GM4VjggMVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0WLRDI4jLvMxmCLXjm927 qMtZmdXb5NBFQkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6UkGkA8I46k+IlGVrbguw txD0Gxj6VWnYd9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIUoz2uyuC73K0QfQ9xwPHK cN+lxAn36Y3gDg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65tMwp920p417Y73hZsYmXF s3OiWa/C/Qdb9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJnbXN5B2tHLynlLGhmjNy U5rZW8IGNBkAUa8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9zSSQKetAooRLOC8acilv jYfZX9nTZlOfQ2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzBttcRVtVKnVla1ahmmqIj LTdZu9icy8HluWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWGSIZ4QtIYabuXY1Q1Qcpy ZckQbYdNBn12PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcWF4uTxeio47WbtaaHfJx0 vCkcleEySiDqUg+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDTBxIh1TaWoU0N8yhNARZr SVb/WhPcelEGlHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8pIobh5AiN2UzsYwi/TlWw Z0IlvPEwHUHfwOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHIdzF1BPbCtVHdj3PlNMSV/ QaYU0/h/ZoreT+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QLvOKFx5BU8GLa/ApyqH9t zVkepqzhJKn2aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtMDgkb6R7Y0nu7h0JIddNN 0jZgcCfzz71PK2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubjwWJXtevN8mzvLRqiHyzG rEZWFSCssBW007J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5Hhc/sRwy9oY74PvRWBN8v NDNIG8jqS3bwQLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ4n1OZ+fDmSvOqcWLdHbq YcfXlrbS1RDZkyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbTtJqmwRV8Z4JhyX4c6njp RUaB55aSY+oZpZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQmuPSjStZUnS9+m38BAAD/ /wMAUEsDBAoAAAAAAAAAIQBVvZbY5AMAAOQDAAAaAAAAY2xpcGJvYXJkL21lZGlhL2ltYWdlMS5w bmeJUE5HDQoaCgAAAA1JSERSAAAAsAAAADAIBgAAALEH8IYAAAABc1JHQgCuzhzpAAAABGdBTUEA ALGPC/xhBQAAAAlwSFlzAAAXEQAAFxEByibzPwAAA3lJREFUeF7tmVtu6jAQhllWu56qD6wFiTWw BCS2wkPf2cIRSIgqxwGc2HOxnTQhHvRb+h6aGNuZ+XxJumpQUIyV9Xp9Z9WW5zUUFDNFFPh0OgFQ PbvdThfYXQGgaiAwMA0EBqaBwMA0EBiYBgID00BgYBoIDEwDgYFpIDAwDQQGpoHAwDQLCvzdXC63 5h9l/11Q99DcWJ2K+dg252j8GY7b5ldqBzDqE/jy01w/cnUhcBba55tOigoFdrBVGAIPBgIvKLDj 8pWqa1/g+PlmAAIvK3AccAg8GAi8sMCOPsnlAv9ufoJ6PefNZ1Tvtk/fb74OyfusH/Hl88lIgWkf fgx07LRvdl/k0Fyz7bdx/myux75Oizh2Eq9XTZiKBOYB7UUtEJgGUCT4XSbgTFByn0qSFHIqgfcH 1k5HML7RArP2H/Eqmay0T7YgzERVAt+EVfkRiIzAgiAqPvjsN2GbfNWJv47Q+9KXk4Ah43N4uZk4 GfzvxgrMecYkGasWmp9MPCakMoHddbaSttdTAme2OBZ8H9yEhIpwXbv0fm67nEzg8Lm1ya70KYwx t8uEJHccmrPUcWpi6hNYWv3c1qYKTBNVsL1pgnQCaMcR3za5n90uJxKY9sMEDJ99hMDJ50gcuZJy z0yFAjs0gTqG1OV0iVLkDxNycZOnu/9MWpz4gu1SELgkyVUJzPLlnzu1O85PnQI70ue4vi5LYgF9 oqQxhNfo323S6A5RkLCZBGaTd1aBlfqpMbyAagWWki7W/WMA44niBN0E7Qkr8nmzjcdd0t+bCCy1 eaXxe9HLm6degR36KhzUZXIUrIghRILzsU+qT2iUaHc/7K/ovPcuAotfZwKEPuamaoF5HamuFFRZ 4kfC6Cqh9RHUEwR8UDhZahBYWB2HC8x/E1Ly+6mpXGAtYKQuTWQSmkhlVYlWk5I6CdQJoPBs908C qxPTo/8nLk3BhH8h1QssB0yoWyxxfiW6Q8620nGmeMVZROD0ajleYOVoR/p+FQYElhKh102KrK2Y JVs8a3fAirOQwHfUvscLLMW46F1gBhYUGJiFCZxYUGYGAoOBCO8DCx0fWiAwGAY7kizz8uaBwGAQ 7H2k9EvMTEBgMAD+Raj4xW8mIDAwDQQGpoHAwDQQGJgGAgPTQGBgGlXg9gYAFogE9n8AYA0IDExz FxgFxW5Zrf4DmyeJwOsk72EAAAAASUVORK5CYIJQSwECLQAUAAYACAAAACEANBL/eBQBAABQAgAA EwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/x wQAAADIBAAALAAAAAAAAAAAAAAAAAEUBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQDCKMd4 KAIAAL8EAAAfAAAAAAAAAAAAAAAAAC8CAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1s UEsBAi0AFAAGAAgAAAAhAFNSiWHSAAAAqwEAACoAAAAAAAAAAAAAAAAAlAQAAGNsaXBib2FyZC9k cmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLAQItABQABgAIAAAAIQD9wVrvzgYAAD0c AAAaAAAAAAAAAAAAAAAAAK4FAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItAAoAAAAA AAAAIQBVvZbY5AMAAOQDAAAaAAAAAAAAAAAAAAAAALQMAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2Ux LnBuZ1BLBQYAAAAABgAGAK8BAADQEAAAAAA= " o:spid="_x0000_s1025"> <v:imagedata o:title="" src="file:///C:\Users\rrh4\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:autoline>False</x:autoline> <x:cf>Pict</x:cf> <x:autopict> <x:mapocx> </x:mapocx></x:autopict></x:sizewithcells></x:clientdata> </v:imagedata></v:shape> A1 <tbody> </tbody>
AM Entries	23/02/2016	24/02/2016	25/02/2016	26/02/2016
AM	AM	AM	AM
Zone 1
Zone 2
Zone 3
Zone 4
Zone 5
Conflict
PM Entries	23/02/2016	24/02/2016	25/02/2016	26/02/2016
PM	PM	PM	PM
Zone 1
Zone 2
Zone 3
Zone 4
Zone 5
Conflict

<colgroup><col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 11pt;" span="4" width="15"> <tbody>
</tbody>