Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i bring numbers from one work sheet to another
example I would like to bring totals from all 52 weeks sheets into a total
worksheet . week 1, week 2 etc into total work sheets |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i bring numbers from one work sheet to another
If the Totals are in the same cell on all sheets just enter
=SUM(Sheet1:Sheet52!F34) on any sheet in any cell. If sheet names are not standard..................... Set up a worksheet sandwich. First you have a Summary sheet. Then a blank sheet named Start. Then a couple of your weekly sheets. Last have a blank sheet named End In Summary sheet enter this formula =SUM(Start:End!F34) As you add sheets insert them between Start and End so's they get picked up by the formula on Summary sheet. Gord Dibben MS Excel MVP On Wed, 30 Jan 2008 14:12:02 -0800, john wrote: example I would like to bring totals from all 52 weeks sheets into a total worksheet . week 1, week 2 etc into total work sheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bring information from one sheet to another | Excel Worksheet Functions | |||
Numbers in work sheet not Formating right | Excel Discussion (Misc queries) | |||
compare two columns data and bring them to another work sheet | Excel Discussion (Misc queries) | |||
HOW DO I CHECK FOR SIMILAR NUMBERS IN A WORK SHEET | Excel Worksheet Functions | |||
how do Ii remove the grey page numbers in a work sheet | Excel Discussion (Misc queries) |