For help in excel Sheet1 (pool of more than 5000 people) in the field for name, id number, date of birth, work, home address and other locations and Sheet2 (annex 1) two tables, click on the button, how to make a stronger field into the corresponding fields in attachment 1, thank you,
A stronger
Id name gender national birth
X X X XXXX XXX XXXXXXXXXXXXXXXXXX
X X X XXXX XXX XXXXXXXXXXXXXXXXXX
Attachment 1:

CodePudding user response:

Sheet2 (annex 1) what is, is that more than 5000 of these tables, if how organizations; If not, it is just one, according to the specific conditions from Sheet1 query information?
In code, not is according to the id number from Sheet1 query to the relevant information to fill in, specific still depends on Sheet2,
If only one table, adjust the Sheet1 put the id number to the front, and then use=match () formula can search, do not need to code,