Automatic line numbering added
pinpinette04
Posted messages
17
Status
Member
-
Mika -
Mika -
Hello everyone!
After looking through various forums for a long time, I'm reaching out to you..
Here it is, I have a task management Excel file. It is filled out and updated every week. It summarizes all the actions to be taken in the coming days, weeks, and months. To make this file more fluid, we need to number the actions. The actions are grouped by categories, so we need to add actions at the beginning. Therefore, we would like this numbering to be automatic and that adding actions at the top does not modify the following actions:
For example:
Week 1
Line 1: action 1
Line 2: action 2
Line 3: action 3
Line 4: action 4
Line 5: action 5
Week 2:
Line 1: action 1
Line 2: action 2
Line 3: action 6
Line 4: action 3
Line 5: action 4
Line 6: action 5
And conversely, we also need the action numbers not to be affected by the deletion of an action.
Week 3:
Line 1: action 1
Line 2: action 2
Line 3: action 6
Line 4: action 3
Line 5: action 5
I tried using the max() function but it creates a circular reference so it's not possible...
I can manage with formulas but I don't know anything about VBA, although I have some basics in programming...
Do you have a solution to propose?
Thank you for reading!
After looking through various forums for a long time, I'm reaching out to you..
Here it is, I have a task management Excel file. It is filled out and updated every week. It summarizes all the actions to be taken in the coming days, weeks, and months. To make this file more fluid, we need to number the actions. The actions are grouped by categories, so we need to add actions at the beginning. Therefore, we would like this numbering to be automatic and that adding actions at the top does not modify the following actions:
For example:
Week 1
Line 1: action 1
Line 2: action 2
Line 3: action 3
Line 4: action 4
Line 5: action 5
Week 2:
Line 1: action 1
Line 2: action 2
Line 3: action 6
Line 4: action 3
Line 5: action 4
Line 6: action 5
And conversely, we also need the action numbers not to be affected by the deletion of an action.
Week 3:
Line 1: action 1
Line 2: action 2
Line 3: action 6
Line 4: action 3
Line 5: action 5
I tried using the max() function but it creates a circular reference so it's not possible...
I can manage with formulas but I don't know anything about VBA, although I have some basics in programming...
Do you have a solution to propose?
Thank you for reading!
7 answers
Hello,
I manage with formulas and you have understood that with the formulas that are constantly recalculated you cannot have a fixed automatic number upon creation (Until proven otherwise!)
If you give us the column that should determine the creation of a new number and the column where it should be inserted, we can provide you with a small macro that would do it as it allows you to freeze the calculated value from your MAX.
--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
I manage with formulas and you have understood that with the formulas that are constantly recalculated you cannot have a fixed automatic number upon creation (Until proven otherwise!)
If you give us the column that should determine the creation of a new number and the column where it should be inserted, we can provide you with a small macro that would do it as it allows you to freeze the calculated value from your MAX.
--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
