unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Guys,
How do you create a reference number for sorting purpose in VBA form?
Example:
On Sheet 1, I will be adding new column in A where will generate a number 1,2,3,4,5,6...etc. up to the last non cell blank cell now in Column B (address details). I will be using it for sorting purposes.
<tbody>
</tbody>
Thank you!
How do you create a reference number for sorting purpose in VBA form?
Example:
On Sheet 1, I will be adding new column in A where will generate a number 1,2,3,4,5,6...etc. up to the last non cell blank cell now in Column B (address details). I will be using it for sorting purposes.
Brooklyn | ||||
District 1 | 3,200 | N/A | ||
United States | ||||
District 2 | 5,000 | N/A | ||
New York | ||||
District 3 | 2,500 | |||
United States | ||||
United States | District 5 | 5,000 |
<tbody>
</tbody>
Thank you!