Dear All,
Hello! First time poster here on the Forum! I just hope that someone can help me before I tear all my hair out over this!
So, I have a lot of data to process, arranged in columns such that Columns B and C are the x and y axis of a plot, then Cols D and E are the next plot, etc. Example data file is here:
http://www.excelforum.com/attachment...1&d=1317898045
I recorded a macro (in the above file) by choosing the first two columns, copying and pasting the data into this file (so Solver could work on the data): http://www.excelforum.com/attachment...1&d=1317898316
Then I ran Solver and got values in cells D3 and G3. Then I copy the value of D3 and put it back into the first file, on the second worksheet "GPa results", into cell C3.
This process then repeats, but the value of D3 from Solver goes into "GPa results" C4, C5 C6 and so on.
Problem is, when I run the recorded macro, it does not seem to run Solver correctly, nor does it copy the values from cell D3 into the "GPa results" worksheet. Usually it finds just one value and then copies it repeatedly!
Here is the code for the first three plots of the recorded macro (included in the data file too):
If anyone can find the problem (and preferably offer a solution!) I would be so grateful!Please Login or Register to view this content.
Cheers,
Bun
EDIT: Maybe I should add that D3 and G3 are the Solver Variables and Target Cell, respectively. In fact, it looks like it is possible to output the G3 values OK, but not the ones I want in D3!
Bookmarks