Spreadsheet that mirrors another spreadsheet and then adds numbers in separate column

Hello All,
I am requesting vba code that shows the same names from the "source list" spreadsheet and then adds numbers in sequential order in a separate column. First, however, the previous numbers and names from the "names and numbers" spreadsheet (see my attachment "initial status"), must be cleared. After the vba clears all names and numbers (except the headings in row one, of course), then the source list names can be inserted in the same order as the source list and then each name is assigned a new number in sequential order. Please see my other attachment - "End result". If you have any other questions, please do not hesitate to contact me.

Best,
Andrewstupendo

Try

Please Login or Register  to view this content.

Hello Jindon,
Thanks for the VBA coding. One thing, however, that I failed to mention is that the macro should search for names
BETWEEN "Names" and "Current End of List" from the Source List spreadsheet
because the range of names will vary (will be dynamic).
The code that you supplied right now includes "Current End of List".
The "Current End of List" cell should not be included. I apologize for the oversight.

Best,
Andrewstupendo

OK, try change to this.

Please Login or Register  to view this content.

Thank you so much! works great. I will list this thread as "solved". Best, Andrewstupendo

Hello Jindon,
There is one more variable that needs to be addressed.
The location of the beginning of the Names on the Source List will also vary.
The word "Names" will not always be in cell A1 in the Source List worksheet.
So in other words, the vba coding should search the dynamic range of names
between "Names" and "End of Current List', no matter where the range is located on the worksheet.
Please note that in the "Numbers and Names" spreadsheet that the headings "Names"
and "Next_Num" will always be in cells A1 and B1, respectively.

Please see the attached example.

Best,
Andrewstupendo