how to add "numbers and ad" with some condition in same cells

[Vishaal]

Hi,

Please check the following and update how can we do that

Sample data

Excel 2010 32 bit

	A​	B​	C​	D​	E​
1​		Sample​	​	​	​
2​
3​
4​
5​
6​		1​	​	​	​
7​		2​
8​		3​
9​		4​	Yes​	​	​
10​		5​	Yes​	​	​
11​		6​	Yes​	Yes​	​
12​		7​	Yes​	Yes​	​
13​		8​	Yes​	Yes​	​
14​		9​	​	Yes​	​
15​		10​	​	Yes​	​
16​		11​
17​		12​
18​		13​
19​		14​
20​		15​	​	​	​
21​

Sheet: Sheet1

Result Data

Excel 2010 32 bit

	A​	B​	C​	D​	E​
1​		Result in same cells B6:D20​	​	​	​
2​
3​
4​
5​
6​		1​	​	​	​
7​		2​
8​		3​
9​		4​	Yes 5​	​	​
10​		5​	Yes 4​	​	​
11​		6​	Yes 3​	Yes 5​	​
12​		7​	Yes 2​	Yes 4​	​
13​		8​	Yes 1​	Yes 3​	​
14​		9​	Yes Ad​	Yes 2​	​
15​		10​	Yes Ad​	Yes 1​	​
16​		11​	Yes Ad​	Yes Ad​
17​		12​	Yes Ad​	Yes Ad​
18​		13​	Yes Ad​	Yes Ad​
19​		14​	Yes Ad​	Yes Ad​
20​		15​	Yes Ad​	Yes Ad​	​
21​

Sheet: Sheet1

help pls

 

[DanteAmor]

In your first example you put it in column B starting in cell B6, now you started in cell A8.Could you indicate where the macro should start?

 

[Vishaal]

Thanks DanteAmor Ji,

great work,

thanks for quick update on my query

thank you very much

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.