LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Summary sheet with text entries.

Hello,

I have a workbook with 235+ pages and counting. The pages are named Sheet1,
Sheet2, etc. to keep it simple.

I need to know how to find out if the word 'yes' was entered into the same
specific cell (B43) on each sheet and have the total number of times this
occured show on my summary sheet, automatically updating as data is entered
and new sheets are created. Is this possible?

Thank you,

tgcali
 
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 can i copy data from a tabbed working sheet to a summary sheet StephenF Excel Discussion (Misc queries) 1 March 15th 07 03:40 PM
Sheet-to-sheet auto-entries of text Ken Johnson Excel Worksheet Functions 0 May 3rd 06 08:38 PM
SPREADSHEET SUMMARY MACRO REMOVING BLANK ENTRIES piper New Users to Excel 1 March 10th 06 09:24 PM
Counting Unique text entries in a sheet with a condition Mike Excel Worksheet Functions 5 October 4th 05 11:56 AM
Summary of Max Hourly entries Al Excel Worksheet Functions 0 June 23rd 05 08:55 PM


All times are GMT +1. The time now is 11:13 PM.

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

About Us

"It's about Microsoft Excel"