Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Totaling cells from p.c. worksheets to a cell on a server workshee
I have six workbooks with 12 sheets each and multiple colums whcih I have
totaled with formulas. I need to link those colum totals to a central worksheet on the server. I am having trouble linking colum totals from six different workbooks to a single cell total on the server. I would like to use links because I want to automate this process as much as possible. |
#2
|
|||
|
|||
I think I'd put the totals for each of those 72 worksheets in row 1 of each
worksheet. Then they'll be easy to find. Then I'd dedicate a worksheet with formulas to retrieve all the totals that I wanted. Then total those cells and use it where I wanted. clemrogan wrote: I have six workbooks with 12 sheets each and multiple colums whcih I have totaled with formulas. I need to link those colum totals to a central worksheet on the server. I am having trouble linking colum totals from six different workbooks to a single cell total on the server. I would like to use links because I want to automate this process as much as possible. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
copying cells from other worksheets | Excel Discussion (Misc queries) | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |