Hi,

I would like a solution (preferably a VBA) to an autofill problem.

I have attached a sample report showing the Data and the Result expected.

I would like the name of the Salesman to appear under column A, ONLY when there is data present in column B to F.

Autofill.xlsx

Regards,
Siyab