View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ME Pike ME Pike is offline
external usenet poster
 
Posts: 1
Default Copy Formula Macro

I have the following formulas:
cell h3: =H3+SUMIF(G$3:$H3,"<x",E$3:$F3)
cell i3: =H2-E3

Assume my current cursor position is cell i53. I would
like a macro that would copy the above formulas down
columns H and I to the row above the active cell (row 52).

Any Ideas? Thanks,

Matt