Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a large data table. I need to create extra tabs based on the following
criteria: Each tab represents only 1 GL account number, from Column C The data on each tab is displayed as Office codes across by Month names down. Office codes are in column B. Month NUMBERS (from an =MONTH based on another cell's contents) is in column H. Assume an absolute reference on each GL tab at $B$7 where the GL code is entered. Numbers to be sumed by Month/Office Code on the gL tab are in G & H (Capital and Operational expenses) of the main table. I have done ADDRESS and INDIRECT and all sots of compounded formulas, but I am super stumped here. Any assistance would be terrific. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract multi level data | Excel Discussion (Misc queries) | |||
Costed Multi Level BOM | Excel Discussion (Misc queries) | |||
How do I edit data categorylabels in a multi-level vertical axis? | Charts and Charting in Excel | |||
Multi - Level Question involving Data Mapping and Formulation | Excel Worksheet Functions | |||
Multi-level Subtotals with Excel 5.0 data | Excel Worksheet Functions |