Updating formulas from one worksheet to another

  • Thread starter Thread starter Pickels
  • Start date Start date
P

Pickels

I have countif formulas on individual worksheets to
calculate the occurrence of certain variables. I have a
totals worksheet where I need the values to appear and
update automatically as the values change on the
individual worksheets. How can I copy/transfer all of the
values from the individual worksheets to the totals
worksheet without having to click "=" and then pick up
the formula from each cell from each individual worksheet
AND have those values updated as the values are updated
on the individual worksheets?
 
Hi Pickles,
You could type in the same formula you would generate by that
method.

If you want to pull in a value to the right of cell with a value of "Total"
you can use VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm

If you have a Total you might need to use OFFSET in your
formulas to simply usage as in
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

A page you might find interesting is
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
but your data is moving around so it wouldn't suit your problem.
May be of interest in collecting the names of the worksheets
for your master list.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top