Click event theory

[PHxLantern]

Hello there,

I tried to ask a very complicated question not to long ago, and I may have screwed up what I was trying to figure out.
So here goes a second try in a different way.
My question is such.
Can you click on a cell populated with let's say a word or basic string of numbers (like a part number for a product) and have data pulled from another cell that otherwise matches the cell you clicked on, and pastes it in an empty cell?
So for example I have A2 and B2 populated, I click on either. It the pulls data or a text string from, say, H2 and pastes it directly to D2. And if I go down further down the list and click on say B14 it grabs and pastes from h14 to D3, so on and so forth.
I cant use a drop down list since the amount of items I have is large and makes it hard to read.
Any help on this question is appreciated.

 

[Logit]

In the Sheet level module there is the following macro selection for double-clicking :

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

End Sub

You can create a macro within it that searches for the data you mentioned ... and if located, it copies and pastes that data into the cell desired.