daveandsiobhan
New Member
- Joined
- Apr 1, 2013
- Messages
- 2
Hi Folks,
Hope somebody out there can help on this one. This is my first post and I have looked on the forums but can't see anything close enough to what I need. I wanted to set up a macro to automate goal seek on a range of cells. I have only very basic macro experience so am struggling a little. I've attached a short extract below of the spreadsheet I'm working on (the full one has a few thousand lines of data) which I hope illustrates what I'm trying to do. I hope this is enough info.
Many thanks in anticipation.
Dave
<colgroup><col style="width: 48pt;" span="10" width="64"> <col style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" span="2" width="20"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;" width="106"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>
Hope somebody out there can help on this one. This is my first post and I have looked on the forums but can't see anything close enough to what I need. I wanted to set up a macro to automate goal seek on a range of cells. I have only very basic macro experience so am struggling a little. I've attached a short extract below of the spreadsheet I'm working on (the full one has a few thousand lines of data) which I hope illustrates what I'm trying to do. I hope this is enough info.
Many thanks in anticipation.
Dave
jan | feb | mar | apr | may | jun | jul | aug | Avg | New Avg | ||||
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
34 | 20 | 43 | 43 | 43 | 43 | 43 | 43 | 35 | 39 | ||||
33 | 43 | 44 | 44 | 44 | 44 | 44 | 44 | 23 | 43 | Goal seek | |||
234 | 434 | 545 | 545 | 545 | 545 | 545 | 545 | 88 | 492 | ||||
13 | 11 | 32 | 32 | 32 | 32 | 32 | 32 | 66 | 27 | set cell | |||
13 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 14 | 39 | to value | |||
221 | 332 | 333 | 333 | 333 | 333 | 333 | 333 | 46 | 319 | by changing cell | |||
111 | 137 | 3417 | 3417 | 3417 | 3417 | 3417 | 3417 | 464 | 2593 | ||||
107 | 109 | 20 | 20 | 20 | 20 | 20 | 20 | 2 | 42 | ||||
103 | 82 | 43 | 43 | 43 | 43 | 43 | 43 | 24 | 55 | ||||
99 | 54 | 106 | 106 | 106 | 106 | 106 | 106 | 64 | 98 | ||||
95 | 27 | 168 | 168 | 168 | 168 | 168 | 168 | 433 | 141 | ||||
91 | 0 | 231 | 231 | 231 | 231 | 231 | 231 | 302 | 184 | ||||
87 | 28 | 293 | 293 | 293 | 293 | 293 | 293 | 3 | 234 | ||||
83 | 55 | 356 | 356 | 356 | 356 | 356 | 356 | 33 | 284 | ||||
79 | 83 | 418 | 418 | 418 | 418 | 418 | 418 | 55 | 334 | ||||
75 | 110 | 481 | 481 | 481 | 481 | 481 | 481 | 556 | 384 | ||||
72 | 138 | 543 | 543 | 543 | 543 | 543 | 543 | 66 | 433 | ||||
68 | 165 | 606 | 606 | 606 | 606 | 606 | 606 | 41 | 483 |
<colgroup><col style="width: 48pt;" span="10" width="64"> <col style="width: 15pt; mso-width-source: userset; mso-width-alt: 731;" span="2" width="20"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;" width="106"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>