Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Designing a flexible reporting template
Ciara
Create a Defined Name for all the formulas you use often. Then in your sheet instead of typing the formula you have =dfSelectMonth Be carefull when editing a defined Formula as their references are all relative .. do it only from a cell where your formula is used. both file size and recalc speed should imporve dramatically. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "CiaraG" wrote: 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 |
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 | |||
Designing Form | New Users to Excel | |||
Designing a Form | Excel Discussion (Misc queries) | |||
I need help formating a template for finanical reporting | Charts and Charting in Excel |