Excel database help

Thread: Excel database help

  1. satzzz's Avatar

    satzzz said:

    Default Excel database help

    Gents,
    I hope someone can help with the attached database. I've nearly sorted it for what I want it t do apart from one thing. That one thing being is that when a part number is in various DEL SEQUENCE,STOCKROOMS and MAX LEVELS I want them all to appear instead of just the first option. For example part number 1015597 has 5 DEL SEQUENCES so I would want ALL 5 to appear in cell F10.
    Hope you can understand.
    [Only registered and activated users can see links. ]
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....
     
  2. Squizza's Avatar

    Squizza said:

    Default Re: Excel database help

    Hey,

    I think you need to use CONCATENATE : [Only registered and activated users can see links. ]

    Failing that you might have to add a Macro.
     
  3. akimba's Avatar

    akimba said:

    Default Re: Excel database help

    All done :-)

    Not as easy as squizza says you need to use an INDEX array to get the results and then concatenate them together
    Not got space to upload to here but you can get from this link [Only registered and activated users can see links. ]
     
  4. satzzz's Avatar

    satzzz said:

    Default Re: Excel database help

    Thanks fella's can't get my head around what you've done so I need to ask if you can do the same so STCKROOMS and MAX LEVELS read all options also and not just the first.
    I've looked at the new sheet and trying to get my head around it. I'll keep trying myself but i the meantime if you could look at it.
    Last edited by satzzz; 13th February 2015 at 12:06 PM.
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....
     
  5. akimba's Avatar

    akimba said:

    Default Re: Excel database help

    Done, I have also tidied up your sheet abit as you had Part number copied about 3 or 4 times when you only really need this once.

    Download from same place I have overwritten rar file with new one ;-)
     
  6. satzzz's Avatar

    satzzz said:

    Default Re: Excel database help

    You're a star mate
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....