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

[TABLE="width: 106"]
<colgroup><col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 11pt;" span="4" width="15"> <tbody>[TR]
[TD="width: 82, bgcolor: transparent"]<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>

<tbody> [TD="class: xl66, width: 82, bgcolor: aqua"] A1 [/TD]
</tbody>

[/TD]
[TD="class: xl72, width: 15, bgcolor: aqua"] [/TD]
[TD="class: xl72, width: 15, bgcolor: aqua"] [/TD]
[TD="class: xl72, width: 15, bgcolor: aqua"] [/TD]
[TD="class: xl72, width: 15, bgcolor: aqua"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: aqua"] [/TD]
[TD="class: xl74, bgcolor: aqua"] [/TD]
[TD="class: xl74, bgcolor: aqua"] [/TD]
[TD="class: xl74, bgcolor: aqua"] [/TD]
[TD="class: xl74, bgcolor: aqua"] [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]AM Entries [/TD]
[TD="class: xl75, bgcolor: transparent"]23/02/2016[/TD]
[TD="class: xl75, bgcolor: transparent"]24/02/2016[/TD]
[TD="class: xl75, bgcolor: transparent"]25/02/2016[/TD]
[TD="class: xl75, bgcolor: transparent"]26/02/2016[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"]AM[/TD]
[TD="class: xl76, bgcolor: transparent"]AM[/TD]
[TD="class: xl76, bgcolor: transparent"]AM[/TD]
[TD="class: xl76, bgcolor: transparent"]AM[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 1[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 2 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 3 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 4[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 5 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: lime"]Conflict[/TD]
[TD="class: xl78, bgcolor: lime"] [/TD]
[TD="class: xl78, bgcolor: lime"] [/TD]
[TD="class: xl78, bgcolor: lime"] [/TD]
[TD="class: xl78, bgcolor: lime"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: aqua"] [/TD]
[TD="class: xl72, bgcolor: aqua"] [/TD]
[TD="class: xl72, bgcolor: aqua"] [/TD]
[TD="class: xl72, bgcolor: aqua"] [/TD]
[TD="class: xl72, bgcolor: aqua"] [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: aqua"] [/TD]
[TD="class: xl80, bgcolor: aqua"] [/TD]
[TD="class: xl80, bgcolor: aqua"] [/TD]
[TD="class: xl80, bgcolor: aqua"] [/TD]
[TD="class: xl80, bgcolor: aqua"] [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]PM Entries [/TD]
[TD="class: xl81, bgcolor: transparent"]23/02/2016[/TD]
[TD="class: xl81, bgcolor: transparent"]24/02/2016[/TD]
[TD="class: xl81, bgcolor: transparent"]25/02/2016[/TD]
[TD="class: xl81, bgcolor: transparent"]26/02/2016[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"]PM[/TD]
[TD="class: xl76, bgcolor: transparent"]PM[/TD]
[TD="class: xl76, bgcolor: transparent"]PM[/TD]
[TD="class: xl76, bgcolor: transparent"]PM[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 1[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 2 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 3 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 4[/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Zone 5 [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: lime"]Conflict[/TD]
[TD="class: xl79, bgcolor: lime"] [/TD]
[TD="class: xl79, bgcolor: lime"] [/TD]
[TD="class: xl79, bgcolor: lime"] [/TD]
[TD="class: xl79, bgcolor: lime"] [/TD]
[/TR]
</tbody>[/TABLE]