Link to home
Start Free TrialLog in
Avatar of bluue s
bluue s

asked on

To insert the given row number for the corresponding row

I have set of numbers that indicate row numbers.
How do i set a indicator in excel to identify the row numbers?

Set of row numbers:

Points outside
6
18
60
71
201
266

1 Header 1 Header 2 Header 3 ...........  Indicate row number
2 ------                                                                
3........
4........
5........
6........                                                                
7......                                                                1
                                                                 

NOTE: observe that 6 is at the 7th row as header is = row 1.
Same concept apply to the rest of the numbers.

Thus to do a macro base to indicate the row number given whatever number stated in the file.

See attached.
Row-Indicator.xlsx
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Can you attach a workbook that shows at least some of the data and what you would like to see after the macro runs?
Avatar of bluue s
bluue s

ASKER

Hi please see my edited question where i have uploaded the file. Thks !
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India 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 bluue s

ASKER

Thanks Subodh for the prompt and accurate solution that i need!
You're welcome!