Loopy question
Have a spreadsheet sent to me
about 250 lines, 12 columns.
There are 60 lines of data, two blank rows
'nother 60 lines, two blank rows, etc.
After my numbers did not foot to the
published totals, discovered that the
person supplying the spreadsheet had
duplicated the same number
in the spreadsheet. (The odds of
having duplicate values in the same column
are extremely slight).
I want to loop through each cell, by column,
starting at cell D2 (data runs from D2 - O2)
store the value in cell D2 as a temporary variable,
compare the tmp variable to each cell in
the same column (going down).
If a match is found, msgbox
should say "OOPS!" (or something like that).
After cycling through all 60 lines (blank rows
separate the each set of 60 lines, so the cursor
will know when to terminate), the cursor
moves back to the top of the same column,
starts at D3, stores that
value, and compares the value in D3 to all cells
in the column directly below it, until a
blank row is found. By the time the cursor
starts comparing the last values in the columns
(such as cell D55/D56, etc.)
there would be only four values to compare with the
three cells below, then three, then two,
and finally the cursor will be comparing
the last value in the column only to itself.
( I suppose the process could terminate before
the last cell is reached).
Upon completing the column, the cursor moves
back to the top of the column, moves Right1,
and starts in column E with cell E2,
until all twelve columns have been audited.
Don't want to compare values between columns
(i.e. cell E55 with cell F55), just the cells in
column E with all the other cells below it in column E.
There are only 250 rows of data, so the whole
process should only take a few minutes.
|