Search / Copy / Paste
Here's my situation:
I have one spreadsheet with 2 columns in them.
Column 1 has values of data
Column 2 has the key codes for the data.
Example:
column 1:
Telephone
TV
Video Camera
Column 2:
A
B
C
cell A1 value: Telphone
cell A2 value: TV
Cell A3 value: Video Camera
Cell B1 value: A
Cell B2 value: B
Cell B3 value: C
I want to be able to create a macro that will search Column 2. Say I
search for the value "A"
The output should be "Telephone" into another cell.
So the steps I need is:
Macro to search for the value from Column 2
Macro to select the value in Column 1 when result is found
Macro to paste the value in Column 1 onto a new cell.
I was thinking of using a command button that you can load in using the
form function in excel.
|