Data Validation and Error Reports

[richard.goodger]

Hi,

Can anyone help me please with a data validation issue. I have a set
of Oracle Tables which are being used in a PeopleSoft Financials
system. There is a requirement to validate all data being input into
an Excel Spreadshet against these Oracle Tables. What would be the
best way of doing this? I have looked at the Data Validation option
within Excel but the volumes of data we are talking about here makes
it not possible.
It would also be nice to create a report (maybe txt file) showing
where, if any, there were errors


Any help would be gratefuly apprecitated.


Richard

 

[KLZA]

Sounds like you should be using the V or H lookup function....