Excel Lookup Table, Duplication and Appending
Budget: $250 – $750 USD
My experience has been search for solutions and then "reverse engineer" the code to fit my needs. I stumble when it comes to For/Next looping and Lookup Table manipulation.
My Workbook has two main worksheets - Master and NameLU. A person's first name can be variable. I want to have VBA which will do the lookup for a match between the Master and Lookup tables, duplicate the Master table record up to 5 times depending on a count in the Lookup table, and then replace the first name with a variation. E.g.: RICHARD could also be known as Rich, Dick, Ricky, or Rick. I would like the additional 4 name variations, and the result appended to the Master table. The Master table may have 300-1000 records to loop through.
I am attaching a more visual explanation.
My Workbook has two main worksheets - Master and NameLU. A person's first name can be variable. I want to have VBA which will do the lookup for a match between the Master and Lookup tables, duplicate the Master table record up to 5 times depending on a count in the Lookup table, and then replace the first name with a variation. E.g.: RICHARD could also be known as Rich, Dick, Ricky, or Rick. I would like the additional 4 name variations, and the result appended to the Master table. The Master table may have 300-1000 records to loop through.
I am attaching a more visual explanation.