Hi All
I am new to Excel functionalities but i learn quickly. So my problem is i have two columns on an Excel Worksheet, One is an identifier number and the second is a serial number. The issue is, the excel data is user entered and the serial numbers are usually incorrect, i need to be able to verify/or straight up replace the values. I have an external database with all the correct information. i need to be able to use the identifier from the excel sheet to query the database, find the record and the corresponding second data value (serial number) and replace the value on the excel sheet.
This needs to be done for each row of the excel sheet , with an unspecified number of rows (Excel data amount will vary everytime)
I was wondering if there is a built in validation function for excel 2007 or maybe a macro i could write
Thanks beforehand for any help you can provide.
Bookmarks