Forum Discussion
Kenechukwu_Oraelosi
Sep 20, 2022Copper Contributor
How to loop adding a column with row numbers beside each column in a dynamic range in Excel 2013
- 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 Sample Data Sheet
9 Replies
Sort By