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. |
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 |
All times are GMT +1. The time now is 09:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com