Enter a sub step number below the insert step

Omer_K

Board Regular
Joined
Apr 9, 2017
Messages
124
Office Version
  1. 365
Hello friends
I'll be glad to receive your help :)
I have work plans arranged by main stages and by sub-stages and sub-sub stages and so on..
Each step is indicated as a number and the sub-steps with a number after a dot
For example:
Main stage 1
Below it can be 1.1
1.2
1.2.1
1.2.2
1.3
1.3.1
1.3.2
1.3.2.1
And so on
I would like to know that if I enter a certain number in the cell - let's say from the numbers I have 1.2.2 then the next step below it will appear (if it does not exist then add a dot and then the number 1 to the step)
And if there is already a step below it then it will add a consecutive number to the step below it
For example, 1.3 then 1.3.3 will appear (alredy have 1.3.1 and 1.3.2)
Hope I was clear - also attach a sample file:
 

Attachments

  • Data.png
    Data.png
    14.2 KB · Views: 27

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top