View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilltrader47 Stilltrader47 is offline
external usenet poster
 
Posts: 36
Default Entering Values and Updating Next Empty Cell in a Range

Please help, I hope there is a macro.

Every time I enter a value in cell j29, I would like it to post to the next
empty cell in range b139:b150. For example, if I enter 24 and it populates
b139, the next value I enter in j29 should post in b140

Thanks - Tom