Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
Multiple sheet data summary | Excel Worksheet Functions | |||
Pull data from multiple sheet | Excel Worksheet Functions | |||
group multiple data in different sheet | Excel Worksheet Functions |