Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenate (Excel 97)

    I have a spreadsheet that is used to keep track of associate errors. An associate can have multiple types of errors on a given day. I would like to know if there is a way to concatenate the number of errors and the err. description (on 2nd worksheet in this work book), and have that information show up on the first worksheet in cell B7 & B8, based upon the date that I have selected in cell B2.

    Thanks in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Concatenate (Excel 97)

    I would keep it simple, sort the table in the Data worksheet and turn on AutoFilter. The user can use the AutoFilter to select a date.

    Otherwise, I would tend to link or import the table in the Data worksheet into an Access database, and create a report based on the imported/linked table.

  3. #3
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate (Excel 97)

    I took your spreadsheet and adjusted it a little. I reformatted your entries and added columns that you can hide. It works as needed but may not suit your needs if you have to stick with the entries as you presented.

    Hopefully seeing it is all the explanation you need if you wish to use the ideas and expand them into a larger spreadsheet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •