I have one worksheet (WORKSHEET 1) that I use to calculate the price of a
product.
This worksheet needs manual input from 13 cells to calculate the end result.

Now I want to create a second overview worksheet (WORKSHEET 2) that lists
all the products with their price.

The overview worksheet should look like a table with many rows.
On each row I want to enter the input data. This data is used by WORKSHEET 1
to calculate the price of each product.

WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and
displays the price in WORKSHEET 2
Then it reads the input data from the second row in WORKSHEET 2 and displays
the price in WORKSHEET 2
etc. etc.

Anybody go a clue on how to do this?

What you need is the DataTable command; this does exactly what you require,
albeit in one sheet. But of course you can copy the table to another sheet.
Take some time to read HELP; some people find the instructions not too
straightforward.
Post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

"John" wrote in message
...
I have one worksheet (WORKSHEET 1) that I use to calculate the price of a
product.
This worksheet needs manual input from 13 cells to calculate the end
result.

Now I want to create a second overview worksheet (WORKSHEET 2) that lists
all the products with their price.

The overview worksheet should look like a table with many rows.
On each row I want to enter the input data. This data is used by WORKSHEET
1
to calculate the price of each product.

WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and
displays the price in WORKSHEET 2
Then it reads the input data from the second row in WORKSHEET 2 and
displays
the price in WORKSHEET 2
etc. etc.

Anybody go a clue on how to do this?

Hi Niek,

This works, but only for one or two different input variables.
What if I have more variables, like in my case 13?

John


"Niek Otten" wrote in message
...
What you need is the DataTable command; this does exactly what you
require, albeit in one sheet. But of course you can copy the table to
another sheet.
Take some time to read HELP; some people find the instructions not too
straightforward.
Post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

"John" wrote in message
...
I have one worksheet (WORKSHEET 1) that I use to calculate the price of a
product.
This worksheet needs manual input from 13 cells to calculate the end
result.

Now I want to create a second overview worksheet (WORKSHEET 2) that lists
all the products with their price.

The overview worksheet should look like a table with many rows.
On each row I want to enter the input data. This data is used by
WORKSHEET 1
to calculate the price of each product.

WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and
displays the price in WORKSHEET 2
Then it reads the input data from the second row in WORKSHEET 2 and
displays
the price in WORKSHEET 2
etc. etc.

Anybody go a clue on how to do this?

You need only one variable: the line number in your table with input
"records"
Just extract all the variables from a table with the line number as INDEX().

--
Kind regards,

Niek Otten


"John" wrote in message
...
Hi Niek,

This works, but only for one or two different input variables.
What if I have more variables, like in my case 13?

John


"Niek Otten" wrote in message
...
What you need is the DataTable command; this does exactly what you
require, albeit in one sheet. But of course you can copy the table to
another sheet.
Take some time to read HELP; some people find the instructions not too
straightforward.
Post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

"John" wrote in message
...
I have one worksheet (WORKSHEET 1) that I use to calculate the price of a
product.
This worksheet needs manual input from 13 cells to calculate the end
result.

Now I want to create a second overview worksheet (WORKSHEET 2) that
lists
all the products with their price.

The overview worksheet should look like a table with many rows.
On each row I want to enter the input data. This data is used by
WORKSHEET 1
to calculate the price of each product.

WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and
displays the price in WORKSHEET 2
Then it reads the input data from the second row in WORKSHEET 2 and
displays
the price in WORKSHEET 2
etc. etc.

Anybody go a clue on how to do this?

It works for as many as you require, as long as they fit on one worksheet.
In your case, don't try to use a two-dimensioned table, just use a
one-dimensioned one.
Each line of input is one row of "food" for the formulas in your worksheet,
and generates one or more answers on that same row.

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
You need only one variable: the line number in your table with input
"records"
Just extract all the variables from a table with the line number as
INDEX().

--
Kind regards,

Niek Otten


"John" wrote in message
...
Hi Niek,

This works, but only for one or two different input variables.
What if I have more variables, like in my case 13?

John


"Niek Otten" wrote in message
...
What you need is the DataTable command; this does exactly what you
require, albeit in one sheet. But of course you can copy the table to
another sheet.
Take some time to read HELP; some people find the instructions not too
straightforward.
Post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

"John" wrote in message
...
I have one worksheet (WORKSHEET 1) that I use to calculate the price of
a
product.
This worksheet needs manual input from 13 cells to calculate the end
result.

Now I want to create a second overview worksheet (WORKSHEET 2) that
lists
all the products with their price.

The overview worksheet should look like a table with many rows.
On each row I want to enter the input data. This data is used by
WORKSHEET 1
to calculate the price of each product.

WORKSHEET 1 reads the input data from the first row in WORKSHEET 2 and
displays the price in WORKSHEET 2
Then it reads the input data from the second row in WORKSHEET 2 and
displays
the price in WORKSHEET 2
etc. etc.

Anybody go a clue on how to do this?