LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Syahira
 
Posts: n/a
Default Forgot to add a sheet to formula.

I'm creating a workbook regarding the traveling expenses of my teammates.
Every sheet and tab have their name and I'm summing the in summary sheet in
the workbook. Then I realised that I've forgot to add another one sheet into
the formula in summary. Here is the example:

Jofri!F8+'Ewe Chean'!F8+Yanti!F8+Huda!F8+'Jee Onn'!F8+'Chee
Keet'!F8+Jessica!F8+Ellis!F8+JJ!F8+Syahira!F8+Ili! F8

So how do I add the missing name / sheet to this formula. There are a lot of
these formulas in the summary sheet.

Thank You


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link cells, sheet to sheet, to recognize row deletions? LeeC Excel Discussion (Misc queries) 30 November 6th 09 10:26 PM
Change sheet name in formula kojimm Excel Worksheet Functions 4 July 15th 05 11:43 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Need formula for sheet & cell reference MPH Excel Worksheet Functions 0 January 16th 05 03:39 PM


All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"