Picking data using vba code

[excel2891]

Hi guys,

i have tried using mirror function but i can't seem to get what i want.

Example: i need to have a set of fixed data on sheet1 and a blank sheet2

sheet1 contains 2 column say column A1 with ''A'' B1 with ''1'', A2 with ''B'', B2 with ''2'' and so on.

so when i go to sheet2 to key in any either A or B in column A, i will be able to pick the right number associated with the fixed data.

Really hope i am able to find the right coding if possible.
Thanks all in advance.