Hello,
I have two worksheets set-up in my workbook "Furniture" & "Fabrics"
On the "Furniture" sheet, I have a list of furniture items with "Upholstery" under column F.
On the "Fabrics" sheet, I have a list of the same furniture items but expanded depending on how many fabrics exist for each furniture item. belong to each item.
For example, item "Chair" has two fabrics, therefore I will have two rows on the "Fabrics" worksheet with more details regarding each fabric (supplier name & fabric reference).
The link here is "BOQ code" which is a unique and non-repetitive string value in the "Furniture" sheet.
I was endlessly trying to figure out a solution through VBA to concatenate all the fabric supplier name and fabric reference ("Fabrics" sheet columns F & G) into the Upholstery cell ("Furniture" sheet column F) based on the "BOQ code".
Can anybody help me with writing a piece of code that does that?
Thanks a lot.
Bookmarks