Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[TheBoy]

Forgot to say thanks, ESP to Guffers, this is now in and working and producing pretty colours for mgmt to pretend they understand.

Thanks !

[Gaffers]

No probs

Glad it is working.  I knew that year in France drinking wine and guzzling french food working hard would come in handy one day

[brendan1983]

I didn't see this in June as I was away on my travels... I used to do a lot of work with array formula's in excel - one thing I would say (depending if your data is in a database somewhere) is to do all of this work on the database side, and then just create an external data source to pull the data into excel.

Or what I do a lot of at the moment is to just generate the reports and calculations in reporting services, and they just get sent out on a schedule in what ever format you want.

This type of thing can be a real pain if you end up with lots of spread sheets with data in, much easier to keep it all in a database and just link to it.

[TheBoy]

I didn't see this in June as I was away on my travels... I used to do a lot of work with array formula's in excel - one thing I would say (depending if your data is in a database somewhere) is to do all of this work on the database side, and then just create an external data source to pull the data into excel.

Or what I do a lot of at the moment is to just generate the reports and calculations in reporting services, and they just get sent out on a schedule in what ever format you want.

This type of thing can be a real pain if you end up with lots of spread sheets with data in, much easier to keep it all in a database and just link to it.

Sadly, we couldn't use a database in this instance, that would have been far too simple and obvious for dim-witted management . It had to use purely Excel, hence my need for help

[Lagondanet]

The Boy. I have an old 'paper' Excel Users Guide gathering dust on the shelf if you want it, but Version 5.0 (I did say it was old!). I could stick it in the post. Might be useful to start a fire. 

[TheBoy]

The Boy. I have an old 'paper' Excel Users Guide gathering dust on the shelf if you want it, but Version 5.0 (I did say it was old!). I could stick it in the post. Might be useful to start a fire. 

No thanks, I try to avoid the software. Office tosser's tool

[Lagondanet]

The Boy. I have an old 'paper' Excel Users Guide gathering dust on the shelf if you want it, but Version 5.0 (I did say it was old!). I could stick it in the post. Might be useful to start a fire. 

No thanks, I try to avoid the software. Office tosser's tool

Noted.