VBA Rank Update

[emerskey21]

Help!

I wanted to automatically adjust the ranking of existing range once I click a button.

Thank you and regards,

 

[StephenCrump]

Your post has been here a while with no response - often a sign that people don't understand the question.

Here's a simplistic interpretation:

	A	B	C
1	Old Rank		New rank
2	1	--->	10
3	2		1
4	3		2
5	4		3
6	5		4
7	6		5
8	7		6
9	8		7
10	9		8
11	10		9
Sheet2

Cell Formulas
Range	Formula
C2:C11	C2	=IF(A2=1,10,A2-1)

Presumably there's more to it than this? Can you please elaborate, including why you envisage needing to click a button?