Select a cell based on column and Row search

[Blacksok]

Hi All,

Need a hand finding the correct way to get this vba code to work

I'm not using tables for a variety of reason.

I want to select a Person and a type of fruit on Sheet 2
If that person has that fruit listed, It should be removed from their Row.


Im trying to select the row based on (Name) on Sheet1
Then i want to search that row for the fruit name based on Sheet2 (Fruit)
Then clear the cell.


Ive already set the variables

Bit stuck with my very limited vba knowledge.

Thanks guys

Dan

Please Login or Register  to view this content.

[TMS]

No error checking but this works:

Please Login or Register  to view this content.

First problem was Dimming Names$ and then trying to find Name. Use Option Explicit. Then some Range references were wrong.