Anothersignalman
New Member
- Joined
- Aug 2, 2011
- Messages
- 1
Hi all,
Putting together part of an assignment for first-year Uni, and one of the functions I want to add in (it's optional but the easiest of the lot) requires a macro that automatically causes a GoalSeek to work.
There are two problems that I have, which I'm not sure how to solve.
1. How do I tell the macro/button in Tab1 to do something in Tab2? I'm assuming this is the problem because I get a "Reference is not valid" error if it's in Tab1, but it works fine in Tab2 where the calculation takes place.
2. As it stands, the goalseek is changing cell C123 to $0.00. But I want it to look for the text "END" in column B, then GoalSeek the adjacent value in column C. It sounds like a VLookup but I'm not really sure, so how do I program that?
Thanks in advance,
Dave
Putting together part of an assignment for first-year Uni, and one of the functions I want to add in (it's optional but the easiest of the lot) requires a macro that automatically causes a GoalSeek to work.
There are two problems that I have, which I'm not sure how to solve.
1. How do I tell the macro/button in Tab1 to do something in Tab2? I'm assuming this is the problem because I get a "Reference is not valid" error if it's in Tab1, but it works fine in Tab2 where the calculation takes place.
2. As it stands, the goalseek is changing cell C123 to $0.00. But I want it to look for the text "END" in column B, then GoalSeek the adjacent value in column C. It sounds like a VLookup but I'm not really sure, so how do I program that?
Thanks in advance,
Dave
