I want to insert a formula in B10 cells which generates a value which brings G12 cell value to 0 (in other words b8 value equals b11).
I have already used Goal Seek and Solver but it generates number just once not on a continuous basis
I want to insert a formula in B10 cells which generates a value which brings G12 cell value to 0 (in other words b8 value equals b11).
I have already used Goal Seek and Solver but it generates number just once not on a continuous basis
Last edited by ysb1234; 07-03-2014 at 07:49 AM.
Oh man..
I have made a shortcut for you.... ie Ctrl + q
just use it will automatically reduce that cell to zero..
check the attachment..
and remember to enable macros.. while opening the workbook
Click * to appreciate...
if helped click *
Hi Vikas,
Thanks for the brilliant solution!..much appreciated
Is it possible to add a formula in the cell instead of Macros and goal seek? So that I dont have to keep refreshing the Goal seek?
Last edited by ysb1234; 07-03-2014 at 06:15 AM.
okay..
I just provide that...
perfect...
I have made it automatic...
check the attachment...
waiting for *
Vikas_Gautam
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Dear Moderator, the title has been changed. Thanks for pointing out
I have made it automatic..
Got the solution man..
waiting for *
Hi Vikas,
Thank you for all the help!
Can you please tell me how did you make it automatic? ... I may have to use the method in other excel sheets. I am a beginner with Macros.
press alt + f11
click sheet one..
copy the following code and paste there....
yes remember to change (General) to worksheet...
waiting for *Please Login or Register to view this content.
Thank you very much
Very useful code, thank you for sharing! The code can be tweaked to make the target value dynamic and it can be extended to include multiple cells. Here is how it reads:
Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("K68").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L68")
Range("K69").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L69")
Range("K70").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L70")
Range("K71").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L71")
Range("K77").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L77")
Range("K80").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L80")
Range("K81").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L81")
Range("K88").GoalSeek Goal:=Range("H90"), ChangingCell:=Range("L88")
End Sub
thank you that has helped a lot... I would like to have more than one automated goal seek in the same sheet i.e. goal seek different cells each from different values?
thanks G
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks