Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic workbook
hey guys... just wondering if anyone knows how I can create a "formula" o something similar that gets the sum from the same location (i.e. A4 from every worksheet. For example, every day of the month has its own worksheet, and there' an extra work sheet that sums the total. I am looking for a way to ad all the worksheets as I create them because initially I start off with sheets (day 1 and month's total). Daily, I add a new sheet, so by th 8th day, I have 9 sheets total. So, is there anyway I can have the last sheet (month's total dynamically change its formula as I add a new worksheet? Thanks in advanced -- younatha ----------------------------------------------------------------------- younathan's Profile: http://www.excelforum.com/member.php...fo&userid=1541 View this thread: http://www.excelforum.com/showthread.php?threadid=27054 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic workbook
Add a worksheet that will always be at the end, just as a dummy, say "Last",
and use =SUM(First:Last!A1) -- HTH RP "younathan" wrote in message ... hey guys... just wondering if anyone knows how I can create a "formula" or something similar that gets the sum from the same location (i.e. A4) from every worksheet. For example, every day of the month has its own worksheet, and there's an extra work sheet that sums the total. I am looking for a way to add all the worksheets as I create them because initially I start off with 2 sheets (day 1 and month's total). Daily, I add a new sheet, so by the 8th day, I have 9 sheets total. So, is there anyway I can have the last sheet (month's total) dynamically change its formula as I add a new worksheet? Thanks in advanced! -- younathan ------------------------------------------------------------------------ younathan's Profile: http://www.excelforum.com/member.php...o&userid=15415 View this thread: http://www.excelforum.com/showthread...hreadid=270547 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic workbook
Put in two extra blank sheets. Name one Start, name one Finish
Now in the summary sheet put in a formula =Sum(Start:Finish!A4) insert your daily sheets between start (at the front) and finish at the end. Put your summary shout outside of these two boundary sheet. -- Regards, Tom Ogilvy "younathan" wrote in message ... hey guys... just wondering if anyone knows how I can create a "formula" or something similar that gets the sum from the same location (i.e. A4) from every worksheet. For example, every day of the month has its own worksheet, and there's an extra work sheet that sums the total. I am looking for a way to add all the worksheets as I create them because initially I start off with 2 sheets (day 1 and month's total). Daily, I add a new sheet, so by the 8th day, I have 9 sheets total. So, is there anyway I can have the last sheet (month's total) dynamically change its formula as I add a new worksheet? Thanks in advanced! -- younathan ------------------------------------------------------------------------ younathan's Profile: http://www.excelforum.com/member.php...o&userid=15415 View this thread: http://www.excelforum.com/showthread...hreadid=270547 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Dynamic link to workbook | Links and Linking in Excel | |||
Dynamic links within workbook | Excel Worksheet Functions | |||
Dynamic reference to workbook | Excel Worksheet Functions | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |