LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr

Sheet 1 is all the attendance data for Directors that are subtotaled by type
of Committee Meeting attended. Sheet 2 is one Director. I would like to
take the subtotals from one Director in Sheet 1 and annotate them in Sheet 2
by putting in the cell address of the forumula from Sheet 1 into Sheet 2. So
as I increase the number of meetings attended in Sheet 1, Sheet 2 will
automatically update. Can I do this?

Beccy
 
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
create a formula in one sheet that would read data from separate sheet automatically QD Excel Discussion (Misc queries) 0 December 8th 06 04:17 AM
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 parag Excel Worksheet Functions 3 June 15th 06 10:29 PM
How do I annotate the cell results from Excel to a Hyperlink? kgagne Excel Discussion (Misc queries) 1 June 9th 05 05:49 PM
Lookup cell contents in on sheet based on a formula in second sheet Michael Wright via OfficeKB.com Excel Worksheet Functions 1 April 30th 05 04:11 PM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 03:11 PM


All times are GMT +1. The time now is 08:36 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"