Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Designing a flexible reporting template
From your formula, it looks like you've got some data in column A that
you are using to determine which columns data you would like some cell to show. If I were you, I would put the names of the months in the cells above the data for that month and use an HLOOKUP formula, like this: =HLOOKUP(A2, C$1:N$25, ROW(A2), FALSE) The ROW(A2) part assumes you would like the data from the same row as the cell that has the month in it. Mark "CiaraG" wrote in message ... I am designing a reports template based on imported data. The imported data comprises of 12 months figures for a number of variables. Normally I would design a template based on a fixed structure so if a new variable was added to the list it would need to be added manually. My formulae within the template would take the form of a nested if statement, so depending on the month selected, the relevant cell vale would be displayed - see below. =IF(A4="January",NominalCSS!D153,IF (A4="February",NominalCSS!E153,IF(A4="March",Nomin alCSS! F153,IF(A4="April",NominalCSS!G153,IF(A4="May",Nom inalCSS! H153,IF(A4="June",NominalCSS!I153,IF(A4="July",Nom inalCSS! J153,IF(A4="August",NominalCSS!K153))))))))+IF (A4="September",NominalCSS!L153,IF(A4="October",No minalCSS! M153,IF(A4="November",NominalCSS!N153,IF (A4="December",NominalCSS!O153,0)))) This large formulae would normally leave my file very large. Has anyone any ideas how I may best design a flexible reporting model or has any examples that I amy review. Thanks in advance. Regards, Ciara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monthly hours reporting template | Excel Discussion (Misc queries) | |||
Is there a template for reporting quarterly payroll taxes? | New Users to Excel | |||
Macro Designing | Excel Discussion (Misc queries) | |||
I need help formating a template for finanical reporting | Charts and Charting in Excel | |||
Designing a flexible reporting template | Excel Programming |