Link to home
Start Free TrialLog in
Avatar of enthuguy
enthuguyFlag for Australia

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
SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of enthuguy

ASKER

Is it possible to achieve using VBA pls? So I can assign a hot key ;)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry I have deleted my comment, as you already got VBA approach by Neeraj.
Thanks Neeraj and Shaun, you guys are awesome
You're welcome! Glad we could help.