Quote:
Originally Posted by gebobs
As far as I know, you can't get pivot tables to display like like that. You could filter the table but that's a pain in the arse.
Access can do it, fer sure. So long as you don't need to collaborate with anyone, then that would be the easiest way. Overkill, as Arvi said earlier.
|
Many thanks everyone for your help with this, I really appreciate it. I have learnt so much on both Excel and Access.
Just need to work out for myself the best way of doing things.
Thanks again.
Rob