• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How do I AutoFill down in one column, using the row count of another column?
#1
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.


Attached Files
.xlsm   Book3.xlsm (Size: 10.19 KB / Downloads: 8)
  Reply
#2
(23-May-2017, 03:18 PM)Mohit Sharma Wrote: 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.


Attached Files
.xlsm   Book3.xlsm (Size: 15.78 KB / Downloads: 19)
  Reply
#3
(23-May-2017, 04:51 PM)Aman Kumar Wrote:
(23-May-2017, 03:18 PM)Mohit Sharma Wrote: 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.
  Reply
#4
Good Attempt. Absolutely right.
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply
#5
(23-May-2017, 05:18 PM)Vivekananda Sinha Wrote: Good Attempt. Absolutely right.

I think sir it is second Brain Storming  course platform to learning tricky & innovated  questions in various languages.  Smile Smile Smile
  Reply
#6
(23-May-2017, 05:17 PM)Mohit Sharma Wrote:
(23-May-2017, 04:51 PM)Aman Kumar Wrote:
(23-May-2017, 03:18 PM)Mohit Sharma Wrote: 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.
  Reply
#7
(23-May-2017, 06:15 PM)Aman Kumar Wrote:
(23-May-2017, 05:17 PM)Mohit Sharma Wrote:
(23-May-2017, 04:51 PM)Aman Kumar Wrote:
(23-May-2017, 03:18 PM)Mohit Sharma Wrote: 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.


Attached Files
.xlsx   Book3.xlsx (Size: 8.45 KB / Downloads: 6)
  Reply
#8
The same way. Just take the data from Raange I2 with the same logic.
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply


Related Topics
Topic Author Replies Views Last Post
Wink Text to Columns Text to Column Gourav Kumar 1 1,959 21-Jul-2017, 09:06 AM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)