Hi all,
New here and pretty new to Excel formulas and VBA, so bear with me...
when I select a value from a drop down in column B on sheet 1 I need a lookup to a table in sheet 2 to loop through the table and set all the rows on sheet 1 where A1 matches in sheet 2 A1. the number of rows can...