Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ID numbers
I have a sheet containg rows of data, column A has an ID
number. For example - 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. Users amend the ID number and click a button which sorts the sheet in ID ascending order. The user may want to amalgamate 1 and 7 so he will change the 1 to a 7 and click the sort button: Before clicking 7, 2, 3, 4, 5, 6, 7, 8, 9, 10 After clicking 2, 3, 4, 5, 6, 7, 7, 8, 9, 10 What I want to add on to the end of the sort macro is a bit of code that will renumber the ID's so that they make sense, that is, start at 1 and don't have any gaps. Is this possible? Thanks in advance. Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel change a group of positive numbers to negitive numbers | Excel Discussion (Misc queries) | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |