enthuguy
asked on
What is the best way to re-number row value from 1 to visible rows only in excel
hi EE,
1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make it "No" column to start from 1 to visible rows only with data. In this scenario re-number 1 to 8
4. Macro (Use relative reference) with VBA and assign a short cut key?
Pls check the attached sample excel sheet and help.
Thanks in advance.
sample_xls_auto_number.xlsx
1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make it "No" column to start from 1 to visible rows only with data. In this scenario re-number 1 to 8
4. Macro (Use relative reference) with VBA and assign a short cut key?
Pls check the attached sample excel sheet and help.
Thanks in advance.
sample_xls_auto_number.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry I have deleted my comment, as you already got VBA approach by Neeraj.
ASKER
Thanks Neeraj and Shaun, you guys are awesome
You're welcome! Glad we could help.
ASKER