View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
irealtymods irealtymods is offline
external usenet poster
 
Posts: 11
Default macro to sum with offset in 2 cell as other cell changed

I need to create macro with this scenario:
F - quantity
H - 1 serial
I - 2 serial
For example some cells:

H644 =SUM(I643+1)
I644 =SUM(I643+F644)
So when I put some number in cell F644, sums correctly calculated,
then one by one cell as i enter some in F

Thank you.