Reply to thread

Message: [QUOTE="Polo78 Lacoste, post: 6388992"] Bernie, Im trying to decifer the coding that you did, so I can try to understand your coding and learn VBA more.. Basically, Im still having a problem with the if statement that you place If Cells(r, 1) = "" , the problem is, if the client has only one record, it skips the row and does not place the contents on column B, C, D, on the column F. Also, I noticed the items are still not being placed on column F. I cannot have more than 6 columns, total, regardless of how many items there are for each client. Pls advise what is the vba function/formula to concat and hold myVal to contain all previous items, so when the data is ready to be copied, it will place all the data on column F. Thank you again. BTW, your coding is awesome! Thank you in advance. Newbie to VBA. *** Sent via Developersdex [URL]http://www.developersdex.com[/URL] *** [/QUOTE]