Linking information from one sheet to another (Or something, I'm not sure!)

[ptzohlp]

Hi, guys! This is a fairly complex setup, so please bear with me and let me know if I need to clarify at all. I'm new to a job and the girl I replaced has left, so I'm picking up where she left off. She created an Excel document that I need to recreate for a different format.

The document looks like this:

Screen Shot 2015-04-01 at 8.43.27 AM.png

Basically, we use the information from this sheet (Orders) to fill out the Alano Sheet. Here's how it looks on the Alano sheet:

The pic wasn't loading she click here to see it

We are switching the online store we have set up to a different merchant, and the order export forms with all of the customer orders and information is totally different. We use the "Alano Sheet" as a checkout form for this specific product to help our production team keep track of each order as they fulfill the order. We used to list out each item by hand, but that was quite cumbersome and so my now ex-coworker created this sheet to assist with that.

Here is the set of instructions she left me, it explains how we generate the information for the sheet better than I could:

Screen Shot 2015-04-01 at 8.48.40 AM.png

Long story short, I would ideally like to learn how she put this together so I can remake the sheet using whatever formula (? I'm not even sure if she used formulas, I've scarcely touched Excel so I'm a total newbie ?) to create a new sheet automatically.

Help me, Excel Forum. You're my only hope.

[Pete_UK]

Instead of attaching .png files, which some members cannot view due to problems on the site, attach a sample Excel workbook instead - the FAQ describes how to.

Pete

[simarui]

hi ptzohlp, and welcome to the forum.

unfortunately pictures do very little in terms of helping us solve your problem. can you upload a sample of your data with a tab showing your desired result? if there is any sensitive information in there (names, ID#'s, or for some companies pricing / margin information etc...) you will probably want to replace that with fake data, but the closer you can get to matching the exact format of your data the better.