Hello,

I am new to programming on Excel and was wondering, if someone could provide me some instruction and advice.

The issue is this, I have a chart with a list of users on the left side and on the right-hand side I have cells that are filled with an 'O' ,corresponding to the application they have on their computer. If you are a little confused here is a rough sketch :

--------------------------------------------------------------------------------------------------------------------------
[Cell A1] Users: -|- [Cell B1] MS Paint -|- [Cell C1] MS Excel -|- [Cell D1] Chrome -|-
--------------------------------------------------------------------------------------------------------------------------
[Cell A2] Bob -|- [Cell B2] O -|- [Cell C2] <BLANK> -|- [Cell D2] O -|-
--------------------------------------------------------------------------------------------------------------------------
[Cell A3] Billy -|- [Cell B3] <BLANK>-|- [Cell C3] O -|- [Cell D3] O -|-
---------------------------------------------------------------------------------------------------------------------------
[Cell A4] Bernard -|- [Cell B4] O -|- [Cell C4]<BLANK>-|- [Cell D4]<BLANK>-|-
---------------------------------------------------------------------------------------------------------------------------

So lets say I wanted to see all the applications Bob has, I run the script/formula and it generates a nice window or a new sheet, that shows me his name and the apps he has.

I have a huge list of users and a very large library of apps. It would make life easier, if I could check who has what very easily.

If you can help me, it will be very greatly appreciated! If you can't, then pointing in me in the right direction, either by suggesting a resource where I can learn to-do something like this would be very much appreciated.

I have tried searching online, but I am still confused as to what I should be looking for.

Thanks!!