This worked perfectly! Thank you! Sent from my iPhone
On Mar 10, 2011, at 10:12 PM, Karla Haman <karlaha...@hotmail.com> wrote: > I will give this a shot. Thank you so much. > > Sent from my iPhone > > On Mar 10, 2011, at 9:20 PM, Dave Bonallack <davebonall...@hotmail.com> wrote: > >> Hi, >> One approach is to insert a new blank sheet, call it "END" and move it to >> become the last sheet in the workbook. >> Whenever adding new sheets, make sure they sit before the "END" sheet. >> If your SUM formula was, for example: >> =SUM(Sheet2:Sheet8!A1) >> change it to: >> =SUM(Sheet2:END!A1) >> All sheets between (and including) "Sheet2" and "END" will be included, no >> matter how many there are. >> >> Hope this helps >> Regards - Dave. >> >> >> > Date: Thu, 10 Mar 2011 16:16:37 -0800 >> > Subject: $$Excel-Macros$$ Need a Macro >> > From: karlaha...@hotmail.com >> > To: excel-macros@googlegroups.com >> > >> > I have a tab that totals all of the other tabs in the spreadsheet. I >> > need to be able to add new tabs and have the formulas in the "totals" >> > tab automatically update. >> > >> > How do I do this? >> > >> > -- >> > ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> > http://www.facebook.com/discussexcel >> -- >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel