| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation and Error Reports
Sounds like you should be using the V or H lookup function....
On Aug 14, 12:22 pm, wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation Error | Excel Discussion (Misc queries) | |||
| Print multiple reports from list validation | Excel Programming | |||
| #VALUE# error with Data Validation | Excel Discussion (Misc queries) | |||
| Data Validation error ?? | Excel Worksheet Functions | |||
| error with data validation | Excel Programming | |||
Threaded Mode
