Automatic Numbering without Macro

Hi everyone!

I would need some help with an excel file I am working on.

The calculations in the file are quite straightforward but since I am going to use this file for almost everyday I will be adding new lines and deleting old ones but I would like to avoid manual work as much as possible.

I had two problems which one of them I solved after digging up in web.

My current problem is that I cannot find a way to make excel automatically add a row name (or reference) when I add a new row or in simpler words: ""Numbering of existing fields in the file and numbering of the newly added ones should be assigned automatically""" I already managed to find a solution for the excel to automatically sum a new row if we add one using the offset function.

Basically, I have a certain number of categories and each category has subcategories. Each subcategory has a specific reference for example: PW1. The subcategories for this would be: PW 1.1; PW 1.2 .... and so on.

Is there a way without using VBA to make excel add this reference in the moment that a new row is inserted?
For example, If I want to add A9 or A10 as new rows (in the file attached), is there any way to automatically make excel put like PW 1.2.4 ; 1.2.5 in column A (A9, A10)?

Hello.

I am using MS Excel 2016 currently. But I want to upload and use the file in sharepoint as its easy to share it.

Originally Posted by AliGW

If you are using SharePoint, then you should be using MS365 - please confirm. If you are, then it may be much easier.

Yes, I will be using this file only in sharepoint. My current office in desktop if Plus 2016 but in sharepoint yes, I will use the 365 one. I can switch the desktop one to 365 but MS 2016 Pro feels quite good too. However, I use the desktop version very little as I am mostly working in sharepoint.

Hello.

I installed office 365 in my PC too. Please, can you provide an example of a workaround which I could use?

Thank you in advance