Macros New ID and Update of file

[Vita1605]

Hi there,
I am currently working of form which has ID, I have macro which generates new ID every time I open the file.
I would like to get the data filled in first list to get pasted into second Tab.
I have created buttom Update, but once I hit the buttom all information disappears on INput tab, including ID, of course.
Means, next time when I open the file, I start again from ID 1.
How can I fix it? Thanks

 

[NotoriousPopol]

So, in you 2nd tab, you have a list with all the data previously generated? Do the last row in the 2nd tab contain the last ID generated?

 

[Vita1605]

First column ID's

 

[NotoriousPopol]

So, in the 2nd tab, first column, you have all the ID's ever created right? And the last one is in the last row?

 

[Vita1605]

It is live document, the form (tab 1) that will be filled in by users on regular basis. Tab 2 will give overview.