Range How do I AutoFill down in one column, using the row count of another column?

[Mohit Sharma]

Hi,

How do I AutoFill down in one column, using the row count of another column? i have attached the excel file and desired output. if you don't understand in my questions.

[Aman Kumar]

Hi,

How do I AutoFill down in one column, using the row count of another column? i have attached the excel file and desired output. if you don't understand in my questions.

Hi mohit,

Please find attached file, i hope this works.

Vivek Sir, Please check whether i have done right or some improvement should be consider.

[Mohit Sharma]

Hi,

How do I AutoFill down in one column, using the row count of another column? i have attached the excel file and desired output. if you don't understand in my questions.

Hi mohit,

Please find attached file, i hope this works.

Vivek Sir, Please check whether i have done right or some improvement should be consider.

Hi Aman,

thanks a lot. it's working but Please describe why did this code:- While Cells(i, 1) <> "" this code.

[Vivekananda Sinha]

Good Attempt. Absolutely right.

[Mohit Sharma]

Good Attempt. Absolutely right.

I think sir it is second Brain Storming  course platform to learning tricky & innovated  questions in various languages. 

[Aman Kumar]

Hi,

How do I AutoFill down in one column, using the row count of another column? i have attached the excel file and desired output. if you don't understand in my questions.

Hi mohit,

Please find attached file, i hope this works.

Vivek Sir, Please check whether i have done right or some improvement should be consider.

Hi Aman,

thanks a lot. it's working but Please describe why did this code:- While Cells(i, 1) <> "" this code.

Because if in column 1 there is no data it will automatically stop.

[Mohit Sharma]

Hi,

How do I AutoFill down in one column, using the row count of another column? i have attached the excel file and desired output. if you don't understand in my questions.

Hi mohit,

Please find attached file, i hope this works.

Vivek Sir, Please check whether i have done right or some improvement should be consider.

Hi Aman,

thanks a lot. it's working but Please describe why did this code:- While Cells(i, 1) <> "" this code.

Because if in column 1 there is no data it will automatically stop.

Hi Aman,

I have added one small query in yesterday questions. if have put data in ventes Revenue, than put Ventes & if i have put data yahoo Revenue than put yahoo. i have attached the file for desired input.

[Vivekananda Sinha]

The same way. Just take the data from Raange I2 with the same logic.