eureka18
12-13-2010, 09:27 AM
Hello everyone,
At the moment I am busy doing a research for my studies. In this research I need to make use of the Goal Seek function in Excel:
Set cell A1 (a formula) equal to cell B1 (input) by changing cell C1 (number)
However, I have to do this for 1000 individual cases in the same sheet but with empty rows between them (In other columns there is data on these rows). To explain my problem further I attached an example file of what I mean.
I have looked on the internet but I could not find a working vba function on this problem. I have no experience in programming but I was wondering if someone could help me figuring out this problem.
Eureka18
At the moment I am busy doing a research for my studies. In this research I need to make use of the Goal Seek function in Excel:
Set cell A1 (a formula) equal to cell B1 (input) by changing cell C1 (number)
However, I have to do this for 1000 individual cases in the same sheet but with empty rows between them (In other columns there is data on these rows). To explain my problem further I attached an example file of what I mean.
I have looked on the internet but I could not find a working vba function on this problem. I have no experience in programming but I was wondering if someone could help me figuring out this problem.
Eureka18