can only fill in the last column of data that hasn't been filled yet,
No need to fill in the fields from the start.
only fill in data that doesn't yet exist

in vba same the above function,


now you fill in from beginning to end.