Hi,
So, I posted a thread the other day regarding a problem of mine (which I am not allowed to post the link to because I am too new to the forum) .
Basically I run an equation by changing a cell value on a different sheet, let's call that cell value for "D8" and the sheet for "Value sheet". I then have a cell at another sheet which is "C7" on what we can call "Equation sheet". on the "C7" cell I have used the simple command "='Value sheet'!D8" to get the value from the cell that I change the value on.
I then run the following script to solve the equation (the goalseek function):
_______________
________
NOTE: This code is at the "Equation sheet"
So, I now want to have another sheet that we can call "Solution sheet" where I basically want to have several columns with empty values with one exception which would be a column with a dropdown box where I can select between 14 values or so.
I then want about twenty rows where I can change one column from the dropdown box described above, which by it self is no trouble making.
So, by changing a value in one of the rows in the "Solution sheet" I want the value that I change to transfer to the "Value sheet", which again will run the program.
To solve this I got the following tip the other day:
_______________________
____________________________
I have not tried it yet, but I am wondering on which sheet this one should by pasted? I guess it has to be the "Solution Sheet" since it has no reference to another sheet.
So, let's say that I made it so far. Now when the code runs and solve the equation for the selected variable, I want it to immediately copy 6 values that we get from the equation into the "Solution sheet". But I need the values to be copied to the same row that I changed the value, and after they are copied I want them to stay there until I change something on the same row again.
I want that for all the 20 rows.
I have tried so much by myself but sometimes it feels like I am shooting in the dark Any help is highly appreciated!
Please feel free to comment if anything is not clear.
Bookmarks