Any Excel experts out there?
I've been asked to look at the feasibility of running a macro in Excel that will check entered (mostly cut/pasted) data against a table of valid values.
I've googled 'data validation' etc but this seems to mostly bring back references to drop down lists as data is manually entered into a cell.
The data to be check could be upto 31 columns wide, by any number of lines( 000's or 0000's maybe). I have seen something similar in SQL statements, where a piece of data can be checked to see if it exists in another table....is there something like this available in Excel
VB?
Any advice gratefully received!
