Autofill Text if Criteria are met

[msiyab]

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

[DocAElstein]

Hi Siyab,
This sort of requirement I usually do in VBA with some sort of
__Do While
___ ' do things while certain conditions are met.
__Loop
Type coding.
We are basically needing to do things while certain conditions are met.

---

So…
This is the sort of thing you had:

Row\Col	A	B
1	Sales Analysis Report
2
3	Sales Employee	Area
4
5	John Smith
6		Las Vegas
7
8		Las Vegas total
9
10		Texas
11
12		Texas total
13
14	John Smith total
15
16	Donald Trump
17		New York
18		New York
19
20		New York total

If you run this macro here: https://excelfox.com/forum/showthrea...ll=1#post15704 on that data, then you should get something like this:

Row\Col	A	B
1	Sales Analysis Report
2
3	Sales Employee	Area
4
5	John Smith
6	John Smith	Las Vegas
7
8		Las Vegas total
9
10	John Smith	Texas
11
12		Texas total
13
14	John Smith total
15
16	Donald Trump
17	Donald Trump	New York
18	Donald Trump	New York
19
20		New York total

Alan