Recent content by chrismarshall81

Apologies I noticed the table I pasted in didn't come through properly. I want to be able to turn this sample data set: ID Product Comp1 Prod 1 Comp1 Prod 2 Comp1 Prod 3 Comp1 Prod 4 Comp2 Prod 5 Comp2 Prod 6 Comp2 Prod 7 Into this ID Product Comp1 Prod 1, Prod 2, Prod 3, Prod 4 Comp2 Prod 5...

Hi I need to concatenate some data for a report but unsure how to do it. Basically I have data that looks like this: IDProductComp 1prod 1Comp 1prod 2Comp 1prod 3Comp 1prod 4Comp 2prod 5Comp 2prod 6Comp 2prod 7 But I want it to look like this: IDProductComp 1prod 1, prod 2, prod 3, prod...

Hi, I seem to have forgotten a lot of my vba coding knowledge as I haven't used it for years so thought I would reach out for some help I have a small database that I am using to do some integrity checks to a large datafile on a monthly basis. The name and location of the file changes each...