Excel - Efficient 4 table procedure

  • Thread starter Thread starter Excel-erate2004
  • Start date Start date
E

Excel-erate2004

Hello,

I'm not totally sure how to explain this, but here goes:

My spreadsheet carries out various calculations automatically from use
input.

I have a listing of 29 species, I also have to enter multiple value
for each life stage per species of which there is 4 life stages.
So theoretically I would have to create (29 species X 4 life stages
116 tables.

What I would like to be able to do is just create a basic 4 table lif
stage sheet from which I could execute the calculations
for one species at a time and have them saved in a final calculation
sheet.

So basically after each calculation on the final calculation sheet,
would want the values "bumped down" each time and not delete the las
set of calculated values.

Is this possible, how complex would it be
 
It would probably take a macro, because you want to change calculated values
into a permanent record.

It shouldn't be terribly difficult.

However, it seems like you could enter 29 species in a column and put your
calculations on the same row. then drag fill them down the columns to get
the formulas for the remaining 28.
 
One thing that I failed to mention is that the user will have to choos
what species they want, more than likely not all 29 species will b
chosen at one time.

So really I need something dynamic, whereby as stated before I can us
the 4 tables over and over again by creating a Macro to clear out th
cells, but at the same time saving each "calculation transaction" fo
each species in a final summary table.

I hope this further elaborates my situation a little bit.

Basically I could copy & paste the 4 tables 29 times and have th
tables potentially set up to send their data to my summary table, bu
there has to be a more efficient way??

Thanks for your help!

P.S. I have the 4 tables set up the way I do based on a document an
the end users would like to keep the format so I cant change that
 
Back
Top