Need help aggregating data

**glazedfaith** · 11-29-2010, 02:39 PM

What I have is childishly basic, but for now it is functional. I haven't done any serious excel work in about 10 years. I would probably have to completely recreate the whole thing to get any workability out of it.

Basically I'd like the first page to be a master listing showing where each item number can be found. Please forgive my lack of knowledge on the matter. Thanks for your help.

**Lifesigns** · 11-29-2010, 03:44 PM

I've had a bit of a look and was just wondering, do you have a list of all the items i.e. do you know all the SKU?

What version of Excel are you using?

**glazedfaith** · 11-29-2010, 04:03 PM

I can easily assemble them if I need to. I'd just copy and paste them all into a list, sort, and remove duplicates. I'm using excel 2007

**Lifesigns** · 11-30-2010, 01:25 PM

Hi, I've attached an example of a way I think you can achieve this.

All you need to do is add all the items to the relevant Bays and then list them all on the Index sheet, their location will appear in Column C. You can sort the SKU's or filter for specific ones and still get their locations you can also sort based on locations.

I've created Hyperlinks to Bays A & B on the left so you can easily navigate to where the items are. When you click it takes you to the Bay number and then you just have to expand the group. You can create the rest if you think that's useful.

There are always many ways of doing these kinds of things but I find it is easier to work with one data sheet, especially if you have to make changes.

I understand SKU's are Unique but just so you know the formula will only find the first Location of a SKU if it is listed in more than one bay.

The formulas are on the Bays sheet also grouped in Columns E-H. I've also changed the file format to *.xlsx it's smaller and has all the benefits of Excel 2007.

Hope that helps