Here is my spreadsheet. What I want to happen is: I enter data in the sheets marked
Shoulders etc.and that data to then be put in specific areas of
Normal based on what is in the location field of
Shoulders etc sheets.
For example, under the
Helm tab there is:
Item Level Item Name DPS Increase Item Location 483 Firebird's Helmet +2171.93 Sha of Fear - Terrace of Endless Spring (LFR) 483 Crown of the Doomed Empress +211.27 Grand Empress Shek'zeer - Heart of Fear (LFR)
I want the
LFR Raids sheet to list
Firebird's Helmet under the
Terrace of Endless Spring section automagically and then it would put
Crown of the Doomed Empress in the
Heart of Fear section of the
LFR but it would also grab anything that I have input from
Terrace of Endless Spring from the other sheets (neck, legs, gloves, etc) in there as well.
My formatting is different a little from the two sheets but I will change that if this request is able to be performed.