Excel 2010 VBA to create an index page based on table of contents

[ReportSmithing]

I would like to take values from a single sheet and create an index based off of a table of contents. I have imported a table of contents that lists multiple departments and their page numbers in column A and B...

Department Page
Finance 1
Finance 2
Finance 3
Finance 25
Finance 60

...and I would like to return only one department with multiple pages just as an index would work...

Department Page
Finance 1-3,25,60

 

[SkipVought]

hi,

Sounds like an interesting challenge,

What are you stuck on?

Please post the code you need help with.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}