 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Multiple sheets
Hi I have several workbooks with a sheet in for each day (W1Mo etc) which all link to a daily totals sheet in a seperate workbook. What I've done is named the total figure cell in each column and then linked that to the daily sheet, but I have approx 120 named cells per workbook. Is there an easier/better way? Thanks Wendy Why are you using named cells? This will take longer to set up than normal cell references. Pete > Hi > [quoted text clipped - 7 lines] > > Wendy I thought it would be easier linking to the totals sheets. Wendy Why are you using named cells? This will take longer to set up than normal cell references. Pete On Jan 25, 10:01 am, "Wendy" <we...@sunnygirl.com> wrote: > Hi > [quoted text clipped - 8 lines] > > Wendy But now you are finding that it is a bit tedious to use the names. You don't need to remove them, but I think it will be easier to use normal cell references in the linking formulae - if there is some relationship between the cells you want to link, then copy/paste can adjust the references automatically. Pete > I thought it would be easier linking to the totals sheets. > [quoted text clipped - 21 lines] > > - Show quoted text - Wendy If you have the worksheet names in your summary spreadsheet, say in cells A1 to A120 then you can use the "INDIRECT" command in cells B1:b120 to reference the other worksheets. For example if you had - a worksheet called "Jan", - Your desired total on the Jan sheet was in A1 - cell a3 in your summary worksheet contained "Jan" - Put the following in cell B3: =INDIRECT(A3&"!A1") This will then bring in the value from cell A1 on the worksheet Jan. With the power of drag and drop you can quickly fill in the remainder formulae. You will need to have all the worksheet names on your summary sheet though! Stew The bad news is that the OP said the data was in a separate workbook. And =indirect() won't work if the "sending" workbook is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help. > Wendy > [quoted text clipped - 15 lines] > > Stew  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.