View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Barbe[_2_] David Barbe[_2_] is offline
external usenet poster
 
Posts: 3
Default autoincrementing dde link

Great! That works well! I appreciate your response!

"Juskalux" wrote:

Try this: In each dde link address cell except the first one, simply type in
the formula "=(ref) + 1", where (ref) is a cell reference to the previous
address. Now each cell with this formula will always be one greater than the
last one. You can just copy the formula into every cell you need.