Hi All,
My data is in AS9:AT.....(xLUp)
ColumnAS contains a 2 letter code such as AA,AB,AC,AD,AE etc.
ColumnAT contains numbers beside the codes, such as 9, 15, 38, 7, 62.
I wish to select via an input box, a code or codes, say AA and AC, then
copy the data to BS30:BT.....
So in my example BS30:BT31 would contain AA 9 and AC 38 respectively.
Could anyone help with a macro to do this.
Thankyou.
RC
My data is in AS9:AT.....(xLUp)
ColumnAS contains a 2 letter code such as AA,AB,AC,AD,AE etc.
ColumnAT contains numbers beside the codes, such as 9, 15, 38, 7, 62.
I wish to select via an input box, a code or codes, say AA and AC, then
copy the data to BS30:BT.....
So in my example BS30:BT31 would contain AA 9 and AC 38 respectively.
Could anyone help with a macro to do this.
Thankyou.
RC