Nov 18 2021 05:09 AM - edited Nov 18 2021 05:36 AM
Hello,
thanks for the fast and easy problem solving on my last request.
Here i got another problem, where i cant find any solution:
When i insert a new cell between 2.5 and 2.6, it shows up like this:
then I have to manually change the correct numbering, i.e. the following numbers from cell A30.
Is there a possibility to set the whole thing continuously, so that when a new cell is created, this happening automatically for example 2.5 and the rest is automatically adjusted to 2.6, 2.7 and so on?
Thanks in advance.
Nov 18 2021 05:49 AM
Automatisches Nummerieren von Zeilen
Im Gegensatz zu anderen Microsoft Office-Programmen gibt es in Excel keine Schaltfläche, über die Daten automatisch nummeriert werden können. Sie können Datenzeilen aber einfach fortlaufende Nummern hinzufügen, indem Sie das Ausfüllkästchen ziehen, damit eine Spalte mit einer Reihe von Zahlen ausgefüllt wird, oder indem Sie die Funktion ZEILE verwenden.
Hoffe das ich Ihnen mit diesen Informationen/Links weiterhelfen konnte.
NikolinoDE
Ich weiß das ich nichts Weiß (Sokrates)
Nov 18 2021 05:58 AM
Nov 23 2021 11:26 AM
BUMP, still got no idea how to realize this.
Nov 23 2021 12:17 PM
Here is an approach
Thank you for your patience
Nikolino
I know I don't know anything (Socrates)
Nov 25 2021 09:38 AM
Nov 28 2021 06:24 AM
Nov 28 2021 07:58 AM
Nov 28 2021 08:57 AM
@NikolinoDE
thanks a lot! It worked fine on your sheet, but on my it dont work:
Maybe its because its numbered with 1.1, 1.2 and so on?
You see the empty line between 1.1 and 1.2..
Maybe you can help me here?
Thanks in advance.
Dec 02 2021 11:50 PM
Sorry for the late reply, but private obligations were my priority during this time.
Nevertheless, I have not forgotten your request :)).
Enclosed here again with a sub-table in a tenth (0.1) range.
You can insert lines between the numbers where they are automatically divided into tenths.
After inserting the line, please click elsewhere, so the sub-count can also appear.
The only drawback in this VBA code is you have to enter the basic numbering manually in advance. Doing it with VBA might not be that beneficial,
but you probably know better than I what you need for your project :).
I also wish you a lot of fun and success with Excel.