Automate from cells to put in another cell

[monkeyharris]

Hi all,
Thread heading is the best way i could think to describe what i need. I have a report from our system which shows me the racking location of all products. I also have another workbook that shows racking locations.
How do i create something to automate looking in workbook1 for the location, and putting the code from that table (columnA) it into corresponding location in the warehouse map.
Using the top line as an example, the location is K0302 (column D), i need the code in Column A to appear in the second table above where it says K0302.

THIS IS THE DOWNLOADED REPORT SHOWING PRODUCTS AND THE LOCATION

HERE IS AN EXAMPLE OF THE WAREHOUSE MAP

 

[Legacy 143009]

I see you have reserved 5 rows for each location. What if a 6th code needs to go to that location?

 

[monkeyharris]

I see you have reserved 5 rows for each location. What if a 6th code needs to go to that location?

Hi, The warehouse map locations will be static and don't change. I have noticed though that we could have 2 difference products in one location. Now i will create the map to show K0201a, K0201, K0201b.

This means i can amend locations in the system so the report shows 1 product, 1 location.

 

[monkeyharris]

Hi, The warehouse map locations will be static and don't change. I have noticed though that we could have 2 difference products in one location. Now i will create the map to show K0201a, K0201, K0201b.
View attachment 101380
This means i can amend locations in the system so the report shows 1 product, 1 location.

I meant:

 

[Legacy 143009]

I didn't get it quite. Can you share a sample end result?