peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Create a Table of Contents in Excel for a Price List

Today's challenge was to create a table of contents in Excel, for a downloaded price list. The data came from Crystal Reports and had formatting on the section headings. Some of the headings were repeated, but we didn't want the TOC to include the duplicates.

I've created a table of contents based on sheet [...]

Related Posts Plugin for WordPress, Blogger...