Thread: Iteration Macro
View Single Post
  #1   Report Post  
danielseward408 danielseward408 is offline
Junior Member
 
Posts: 1
Default Iteration Macro

Morning Everyone,

I am not very good at this so I'm hoping someone can help me. I have attached a picture of the spreadsheet that i am working on. My end goal is to have the numbers in column 'D','I' and 'N' to increment by their corresponding input cells in columns 'E','J' and 'O'. The spreadsheet is a record of points awarded so it will be accessed a couple of times a week. Once the calculation has been completed I'd like the input cells to be cleared.
An example would be 10 points awarded to FS 'C3'. i would enter 10 into 'D3', press enter then the cell would clear and 'C3' would increment by 10.

I hope you guys can help me.
Many thanks
Dan
Attached Images