Provided your data are suitably arranged, that's quite possible.
If you could attach a copy of your workbook to a post showing the data structure with some representative data (delete anything sensitive), we'd gladly take a look at it to see what can be done. You can attach files via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|