Countinously calculation problem

[SEO]

Hi

I got (what I think is) a severly complex problem, and I hope some of you can help me.

In Sheet1 I got 12 calculations set up, these calculations require input from 26 variables. These variables have been logged at specific time intervals, and I have this data organised in Sheet2.

Is there anyway I can get excel to insert a set of data (set of data here refering to the values of the variables at a specific time) into the right cells needed to get my calculations correct, storing my results in Sheet3 before clearing the calculation inputs, and repeating the process for the next set of data?

I've tried using macros for this, but I cant get the macro to automatically move on the row of data below.

I hope some of you Excel wizards have som bright ideas for this, because it would save me alot of time.

 

[mvptomlinson]

I'd recommend posting a sample file with representative data to a file sharing site. It will likely make coding a solution MUCH easier.

 

[SEO]

Hi and thanks for replying

You can find a copy of my Excel document here:

http://www.keepandshare.com/doc/view.php?id=1727035&da=y

I've tried to translate the important things into English, the rest is in Norwegian I am sad to say, but I think it will be ok, as the variables are identified by tag numbers. As you probably understand the blue cells is where the variable values go in, and the answers in the yellow, light and dark green cells is what I want to store in Sheet3

I am trying to be abit ahead of time on this one, so the data is not in yet. I've created 4 lines of representative data for you guys to practice on.

Thanks alot

 

[SEO]

Hi again people!

I managed to work my way around the problem so no need to spend alot of effort in solving this problem anymore.

All that was needed was a fresh mind and some alternative thinking