If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating formulas from one worksheet to another
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? |
#2
|
|||
|
|||
Updating formulas from one worksheet to another
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 "Pickels" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|