UMAKEMESIK
Active Member
- Joined
- Oct 3, 2005
- Messages
- 378
I have a work book with two sheets.
Sheet 1 is a look up query sheet.
sheet 2 has all the data
I would like to put a value into cell a1 of sheet 1 - for examples "Box1"
the macro would look in sheet 2 for a value of "box 1" in column A of sheet 2
the macro would then copy the data from sheet 2 in column B that corresponds to the Value of "Box 1"
The value from column b of sheet 2 would then be pasted into sheet 1 "B1"
so the result would look like on sheet 1:
an input value on sheet 1 in A1 with the corresponding info on sheet 1 b1
thanks in advance
Sheet 1 is a look up query sheet.
sheet 2 has all the data
I would like to put a value into cell a1 of sheet 1 - for examples "Box1"
the macro would look in sheet 2 for a value of "box 1" in column A of sheet 2
the macro would then copy the data from sheet 2 in column B that corresponds to the Value of "Box 1"
The value from column b of sheet 2 would then be pasted into sheet 1 "B1"
so the result would look like on sheet 1:
an input value on sheet 1 in A1 with the corresponding info on sheet 1 b1
thanks in advance