Sheets for warehouse bays update based on products in master list

[Kayley]

Hello, I have two spreadsheets I am hoping to combine into one and have to only update one part.

One sheet is an alphabetical list of the products in the warehouse with a list of bay locations next to it.

IE ITEMX CB11 CB21 CB31

Each aisle then has a sheet which is a visual diagram of the bays within the warehouse. Each cell corresponds to a bay. So each cell will have a product despcription written in it and underneath will be the name of the bay (CB11, CB21)

What I would like is to only have to update the alphabetical list and then the 'Map/diagram' pages to update themselves.

I hope this makes sense and somewhere someone knows a formula to achieve this. Thank you.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Formula help" does not tell us about your specific question. I have updated it for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

Although your description gives an idea of what you want to do, a solution is completely dependent on what your data organization looks like. Please attach a sample file, without private data.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[Kayley]

Hopefully this gives you a better idea of what I mean. Please do let me know if it requires more expansion (I am not very good with excel).

Apologies also for the subject I typed four different things and had no idea what I was really asking for if I am honest!

[JeteMc]

Hello Kayley and Welcome to Excel Forum.
This formula reproduces the results that are manually placed on the Isle A sheet:

=IF(A2="","",IFERROR(INDEX('Pallet list by Product'!$A$1:$A$14,AGGREGATE(15,6,ROW($A$1:$A$14)/('Pallet list by Product'!$B$1:$W$14=A2),1)),""))

Select Cell A1 and paste the formula into the formula bar,
Drag the fill handle over to cell L1,
Select (Auto Fill Options) Fill without formatting,
While A1:L1 are still selected simultaneously press the Ctrl and c keys,
Select cell A3 and simultaneously press the Ctrl and v keys,
Select (Paste Options) formulas,
Select cell A5 and simultaneously press the Ctrl and v keys,
Select (Paste Options) formulas...
Let us know if you have any questions.