I have a number of worksheets that each have a data row that I am trying to summarize on another page.
For example, I have ten worksheets, each containing a recipie. On each worksheet in the 2nd column, 5th Row (Cell B5), I have a value for how much water is required. I want to be able to summarize, on a seperate worksheet, how much water is required by each recipie. So I am looking to have a table with each recipie name and each recipies' water requirement.
What about doing this for multiple ingredients? How about indredients that the recipies don't have in common? Is there a way to summarize all the recipies by ingredient on another page?
This message was edited by Cosmos75 on 2002-03-01 11:12
For example, I have ten worksheets, each containing a recipie. On each worksheet in the 2nd column, 5th Row (Cell B5), I have a value for how much water is required. I want to be able to summarize, on a seperate worksheet, how much water is required by each recipie. So I am looking to have a table with each recipie name and each recipies' water requirement.
What about doing this for multiple ingredients? How about indredients that the recipies don't have in common? Is there a way to summarize all the recipies by ingredient on another page?
This message was edited by Cosmos75 on 2002-03-01 11:12