I have two tables, one in each different file.
The first table, let's say in clientnumber.xls, contains only two columns, Client Name and Client Number. It's regularly manually updated and has around 1500 rows.
The second table (clientfinal.xls) is more complex, and is the one I want to do the editing it. It contains around 10 columns. Most columns are already filled in, including Client Name, but Client Number is still empty. I have to find and manually input the corresponding Client Numbe by checking the first table. This takes a lot of time and I'm sure there is a better way to do this, but I'm not sure how, so I can't show any code I tried to write.
Any tips or pointers are greatly appreciated. Thank you!
Bookmarks