If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copying cell value from sheet1 to sheet2 that has same ID

Thread starter fayez_MrExcel
Start date Jul 20, 2007

fayez_MrExcel

Active Member

Jul 20, 2007

I have a huge list of Stock Items in sheet1 (Serial No., Product Name, Item Code ID, Location-A, Location-B placed in A1 – E1) and a Stock Register in sheet2 (Item Code ID, Description, Location Name placed in A1-A3).
One (1) item code in sheet2(Stock Register) can have 1 or 2 location names. What I want to happen is to have a click button in sheet1(Stock Items) wherein if the Item Code ID in sheet1 is equal to Item code ID in sheet 2, it will copy the location name (from sheet2) and COPY it to sheet1 under Location-A and Location-B. If Item Code ID in sheet2 has only 1 location name, then the location name will be copied to Location-A of sheet1, but if it has 2 location name then it will be copied to Location-A & Location-B of sheet1.
Please help…thank