Sheets and books in Excel 2007

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:55 PM GMT

Question

Hello. I'm trying to create a spreadsheet which will total call numbers per agent, per month. So, what I would like is the book would have sheets. On each sheet is the agent name. Then, what I want to know is it possible that when I click on the agent's sheet tab at the bottom of the screen, could it then create more sheets under that one for each month? Basically, a tree? Is that possible?

Answer

No, the basic structure ofcannot be changed, in the sense that, the parent is the workbook and the child is the worksheet (tab). There is no "sub"-worksheet, or "mini"-worksheet.

I would suggest that you rarely if ever would want that, though ... Because this would make it more and more difficult to display data with formulas involving totals, averages, etc.

Advertisement

©2020 eLuminary LLC. All rights reserved.