How to loop adding a column with row numbers beside each column in a dynamic range in Excel 2013

Question

Good day. Been on this for more than a week and can't find a solution. New to VBA. I have a data sheet with multiple columns of data. I would like to add, beside each column, a column with the row numbers of each column, and to do this through the range till it hits an empty column. Something like below. My data looks like the first pic. I'd like a VBA that loops through that and turns it into the second pic. I currently use Excel 2013. Would be grateful for any response

EDIT: had issues adding images so i uploaded them to a hosting site. The first image, what my worksheet currently looks like: https://ibb.co/yXR1jmb

What i would like it to look like: https://ibb.co/s1n4yhP

UPDATE: The excel worksheet with sample data https://fastupload.io/en/KkwiNdiqeAySpbX/file

kenechukwu_oraelosi · Answer

Thank you so much already for your response, for taking your time to look at this. Really grateful honestly.

dexterg_iii · Answer

Kenechukwu_Oraelosi&nbsp;hello, I do not see either of the pics mentioned attached.&nbsp; Please kindly provide so that the community can visualize your intent.&nbsp;&nbsp;&nbsp;Thank you,Dexter

kenechukwu_oraelosi · Answer

New here. How do i add pictures?

dexterg_iii · Answer

Kenechukwu_Oraelosi&nbsp;you should be able paste (or drag &amp; drop as shown below) directly into these message boxes.&nbsp; &nbsp;&nbsp;&nbsp;

kenechukwu_oraelosi · Answer

I'm currently using my phone, an Android

Forum Discussion

How to loop adding a column with row numbers beside each column in a dynamic range in Excel 2013

9 Replies

Resources