View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mdavison mdavison is offline
external usenet poster
 
Posts: 10
Default Crazy multi-level parsing of data

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!