LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver iteration in VBA macro Mike Walker[_2_] Excel Programming 2 April 27th 11 02:49 AM
Having Solver Call a macro for each iteration Andrew Harris Excel Discussion (Misc queries) 2 March 8th 10 04:27 AM
Running a Macro at every Solver Iteration sk[_4_] Excel Programming 4 January 26th 07 12:46 AM
Iteration M. Homayon Excel Discussion (Misc queries) 1 January 11th 06 01:05 AM
How can the range.calculate macro be run with "iteration" and "ma. WCope1 Excel Programming 0 February 1st 05 05:35 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"