Tue 3 May 2011, 15:52Delegate Eva said...
Eva has attended:
Excel Intermediate course
Excel Advanced course
Word Intermediate course
Word Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Macros
would I have to record separate macro for using goal seek on a range of figures running over several years
Tue 3 May 2011, 16:52Trainer Clare said...
RE: macros
Hi Eva,
Running a single macro that goes in an out of goalseek should work. Remember that your 'changing cells' should be constants and not formulas or functions. Also, as we discussed, I would investigate scenarios for this as you might find them easier to manage!
Hope you enjoyed the course today.
Clare
