(Solved) – extract some text from one cell to match the description of another cell

(solved)-–-extract-some-text-from-one-cell-to-match-the-description-of-another-cell

I want to do a macro in excel to extract and match some information. Text is always going to be different, so I’m not sure how to do it in VBA
I need to extract some text from one cell to match the description of another cell.

1.I have one column with the following cell texts:
A1.”Production Floor Wood Working”
A2.”Showroom Offices”

A24.”Storage Basement”

  1. I have another column with the following cell texts:
    B1. (Production Floor Wood Working) – Delanp x 2; (Showroom Offices) – ; (Exterior) – ; (Storage) – ; (Storage Area Finished Goods) – ; (Upholstery Manufacturing) – ; (Sofa Wood Assembly) – ; (Toilets) – ; (Office) – ; (Sewing and Materials) – ; (Storage Basement) – Delanp x5
    B2. (Production Floor Wood Working) – Delanp x 2; (Showroom Offices) – ; (Exterior) – ; (Storage) – ; (Storage Area Finished Goods) – ; (Upholstery Manufacturing) – ; (Sofa Wood Assembly) – ; (Toilets) – ; (Office) – ; (Sewing and Materials) – ; (Storage Basement) – Delanp x5

  2. Now, what I need to do is extract into another column to match information from column A.
    A1.”Production Floor Wood Working” C1. Delanp x 2
    A2.”Showroom Offices”

A24.”Storage Basement” C24. Delanp x5

thanks

Leave a Reply

Your email address will not be published. Required fields are marked *