Hi Everybody,
I am new to this forum and new to Excel.
I need to find a cell that contains a certain value (of my choice)
and copy it to the clipboard, so I can paste that cell value
into any cell of my choice.

Example: Chart below as sample where SKJ is in A1, I42 is in B1 and SPF is in C1, etc.
P4Q is in A16, H1B is in B16, 385 is in C16. etc.



So, If I need to find and copy to clipboard (my choice is) N64 for this example.

I have 2 questions:
1)What formula would I need?
2)How to use a macro for the task?

Thanks in Advance for any help.
Pan


SKJ I42 SPF
DOQ 9X1 3T5
QH1 B4L AOC
TAJ UQL DRK
MSJ MRY K6P
P0T 6K9 RCI
BPJ C1A 7OJ
521 HC5 UPB
UL7 N6U IVA
OPS I5K EJD
3PE PO3 BEE
FQR E11 LDW
UB5 7CN JVI
4MQ OVX F0Q
UCF HN1 7GK
P4Q H1B 385