I have the following in one cell NAME fred /bloggs/ then down to cells
with other info in them before another cell with NAME freda /bloggs/ etc
I have discovered how to check for the existance of "NAME" in a cell but how
can I copy the "fred" and "bloggs" to other cells when the "NAME" exists?
Is it also possible to check the next cell down if "NAME" doesn't appear in
a cell and carry on to the next other cell down so that I get
fred bloggs
freda bloggs
etc ?
--
Thanks Bob