View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Pete[_26_] Pete[_26_] is offline
external usenet poster
 
Posts: 18
Default if cell value matches then copy another cell

Back to DataCollector's suggestion, why can't you add another column
containing a sequence - i.e. fill it with 1,2,3, etc, then you can
always sort the data back into the original sequence, then remove this
column. Like him, I do similar things with upwards of 40,000 rows, so
3,500 shouldn't create too many problems.

Pete