Hi,
What I am doing at the mo is this:-
I have a spread sheet which is used each month for reporting applications,
the data is extracted from a database and contains some duplicates.
I need to check theses duplicates against each other and ensure their result
fields meet certain criteria.
If they Do/Dont then I need to change/Not Change the data in the cells.
For Instance, Col B contains the application numbers, col F Contains the
first part of the test, say it contains the word 'Refused' Col G the next
part say 'Overruled' and Col H the Last part Say 'Unknown'
Now if the next row down contains the same application Number but the
subsequent rows contain the words 'Refused'-'Included' and then 'Unknown' I
need to change the Unkinowns to a different result say 'Mickey Mouse'
I can set up the code in VBA to check the 3 cells and change the last one
depending on the criteria of the other 2 on the spreadsheet as a whole, I can
write the formula on the spreadsheet to check col B for duplicates and return
a word or ref, However what I cant do is marry the 2 together so that the
only cells changed are those appertaining to the duplicate entries.
In essence what I need is a bit of help getting the code to check Col B for
duplicates then do the offset stuff on only those duplicate entries

Cheers
JR