eed
08-16-2004, 07:01 AM
Hi, all,
I'm hoping someone can assist me with this. I work with VBA in Access a lot, but I don't have much experience programming in Excel.
I have a spreadsheet of data, specifically, a list of documents and meetings related to those documents. (I've attached a really over-simplified example to illustrate.) You might have three meetings for Document One, so there are three records, but most of the fields are simply repeated values. I'd like to concatenate all the meetings for a particular document into the cell for just one record. This way you won't have to see multiple records, just multiple values listed in one cell.
But if each document may have any unpredictable number of meetings/records, I'm not sure how to tell Excel to loop through, find all repeated instances of a Document ID number, and concatenate the associated Meeting values into one record, then delete the other records.
I hope this question makes sense. Look at my attached Excel sheet for (better?) illustration. Thanks in advance for any advice!! :blush
I'm hoping someone can assist me with this. I work with VBA in Access a lot, but I don't have much experience programming in Excel.
I have a spreadsheet of data, specifically, a list of documents and meetings related to those documents. (I've attached a really over-simplified example to illustrate.) You might have three meetings for Document One, so there are three records, but most of the fields are simply repeated values. I'd like to concatenate all the meetings for a particular document into the cell for just one record. This way you won't have to see multiple records, just multiple values listed in one cell.
But if each document may have any unpredictable number of meetings/records, I'm not sure how to tell Excel to loop through, find all repeated instances of a Document ID number, and concatenate the associated Meeting values into one record, then delete the other records.
I hope this question makes sense. Look at my attached Excel sheet for (better?) illustration. Thanks in advance for any advice!! :blush