Seems like I have to study up on VBA coding now . Thank you both for your assitance in this regard.

If you wouldn't mind, could you break down the VBA code for me so that I can get an idea of what it's actually doing. As mentioned in my first post the data I will be dealing with will be considerably larger and I would like to be able to customise the VBA code accordingly (i.e. change search range). I just tried adding a few extra pieces of data to the sample and the OutPut tab remained the same. Is there something I need to do to 'initiate/activate' the code so that it continually updates the OutPut tab?