Vista Forums - View Single Post

**FightingScallion** · 03-14-2008

I'm not that great with it, but from what I've seen, MS Access promises to do something like that. I'm not sure to the extent or anything like that, but the capability does exist. I have only started playing with Access; since I have no actual use for it, I'm mostly going through tutorials with no end in mind, so it isn't clicking for me that fast.

Another option would be to jump into the Visual Basic part of Excel and write code for it to do what you're talking about. I can tell you, though, that this is a bit time consuming for a non-dedicated coder. If you have someone like that in your office who has the job of writing support code, it may be worthwhile to give them as a job.

Maybe someone else will have something for you. Still, I would expect that Microsoft would include some capability like that in the Enterprise or Business edition of Excel. If you have Office 2007, it would be worth your while to look at Access as an option. Additionally, MS Groove, InfoPath, and OneNote may help streamline some operations.

Good luck.

03-14-2008	#2 (permalink)
FightingScallion Enthusiast	Re: Excel Reporting... I'm not that great with it, but from what I've seen, MS Access promises to do something like that. I'm not sure to the extent or anything like that, but the capability does exist. I have only started playing with Access; since I have no actual use for it, I'm mostly going through tutorials with no end in mind, so it isn't clicking for me that fast. Another option would be to jump into the Visual Basic part of Excel and write code for it to do what you're talking about. I can tell you, though, that this is a bit time consuming for a non-dedicated coder. If you have someone like that in your office who has the job of writing support code, it may be worthwhile to give them as a job. Maybe someone else will have something for you. Still, I would expect that Microsoft would include some capability like that in the Enterprise or Business edition of Excel. If you have Office 2007, it would be worth your while to look at Access as an option. Additionally, MS Groove, InfoPath, and OneNote may help streamline some operations. Good luck.