Check to see if cell value exists
I can't find anything suitable in my HELP, I did try this
first!
Can anyone else offer any more suggestions/code, please?
-----Original Message-----
Have a look in the visual basic editor HELP for FIND
"Mark" wrote in message
...
I am using Excel 97 and want to be able to check to see
if
a cell value on one sheet is already listed in a range
on
another sheet.
If the cell value is listed then move to the next cell
down, if not listed then copy the value of that cell
into
the next cell available in the range on the sheet.
Can anyone assist with some code please?
Thanks
Mark
.
|