Any Ideas?

I have a workbook that picks up results from a .txt file and puts them in a report. The problem I have is that the database creating the results is in an development stage and through-out this development I have a select number of queries to check the results with. At present I'm checking the results by glancing over each one and comparing results. I need something that will do this checking automatically and flag up any problems. Not too bothered about details but has anyone done something similar or have an idea about the best way to go about it?

cheers

Yes,
I do something similar with txt files.
For statistical data...
I use VLOOKUP, HLOOKUP and variable IF statements on different programs.
CHECK THIS OUT!!!:
http://www.rondebruin.nl/id.htm
Download the Excel Function Dictionary
at the very bottom of the page!!!!!



Feature names in COlA
Nominal In col B
USL in Col C
LSL in Col D
Actual value in column E

..=VLOOKUP(STATS!A1,A1:E321,5,TRUE)

From the site:
What Does It Do ?
This function scans down the row headings at the side of a table to find a
specified item.
When the item is found, it then scans across to pick a cell entry.

Syntax
..=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)
The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left
hand side.
The ColumnToPickFrom is how far across the table the function should look to
pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes,
FALSE for no.

Cheers for reply

Not really what I was after though. Although it may have to be done using a selection of lookups. I was thinking along the line of whether there is a way in vba to check two spreadsheets against each other short of a continous loop comparing values from each cell?