View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnsonlnl29 johnsonlnl29 is offline
external usenet poster
 
Posts: 1
Default Autocopy formula without VB

I would like the Following formula: =E6-B6 (located in cell H6) to autofill
in column H once data is entered in cells E7, B7, E8, B8, etc. Can I do this
without VB? If not, how do I do in VB? I've noticed sometimes it does it and
sometimes it doesn't within different spreadsheets. Not sure if it is a
setting within tool\options or has to be VB. Appreciate assistance given.