Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Compilation sheet representing multiple data from multiple other s

hey thanks for all the help yesterday. Next up...

Say I have a spreadsheet containing 10 worksheets. Each worksheet
represents one employee and has corresponding cell structures for recording
billable and non-billable hours, out of office business, and references for
all of it. I want to have an 11th sheet compile all of their data together,
placing each employee next to all of the others via various charts.

On the sheets, sum formulas keep track of every minute when added, computing
weekly client bill/nonbill totals, monthly, and running grand totals.

It seems easy enough, but referenceing cells by text names gives me trouble,
and I just need to find the section which lyas out how to reference multiple
sheets' data against one another. any tips? should/can another Spreadsheet do
the work? Help?

--
Chris Cornell
No... not that one.
Reply
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 multiple sheet tabs from multiple cells. Robert Maddox Excel Worksheet Functions 17 November 14th 07 10:28 PM
Multiple Sheet, Multiple Criteria Look-Up Function Help Dan Oakes Excel Worksheet Functions 5 December 29th 06 01:37 PM
Multiple sheet data summary jmomorrison Excel Worksheet Functions 1 November 21st 06 08:11 PM
Pull data from multiple sheet jillteresa Excel Worksheet Functions 1 May 19th 06 05:44 PM
group multiple data in different sheet alibaba Excel Worksheet Functions 0 January 6th 06 06:46 AM


All times are GMT +1. The time now is 06:50 AM.

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"