Best approach to make multiple reports from database?

[Spock's Brain]

I have a large database on sheet1 and a drill-down report using sumif's and subtotals on sheet2.
Of course the client now wants additional/ different drill-downs which I can do on additional sheets but recalc times are increasing.
Is there a better/simpler approach? I think I'll have to get into VBA generated reports. ;o(
Thx SB

 

[kmiles]

On 2002-04-09 18:44, Spock's Brain wrote:
I have a large database on sheet1 and a drill-down report using sumif's and subtotals on sheet2.
Of course the client now wants additional/ different drill-downs which I can do on additional sheets but recalc times are increasing.
Is there a better/simpler approach? I think I'll have to get into VBA generated reports. ;o(
Thx SB

Have you tried using a pivot table?

 

[Spock's Brain]

I like pivot tables for "my" work-in-progress stuff but can my end user create pretty presentation reports with the click of a button? (selecting pretty pivot table options from userform). More VBA. ;o)

 

[Legacy 98055]

What about an Access report from Excel?

 

[Spock's Brain]

That would be ideal but would be a quantum leap for my end users. (They are comfortable opening Excel files & clicking buttons).
Pivot tables wouldn't work because I don't need to 'pivot' the data.
Thank you for the suggestion tho'.

 

[Legacy 98055]

Creating reports in VBA = tedious and painful.
At least too me...
Have fun!