Concatenate (Excel 97)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote