Get instant live expert help on I need help with excel table of contents

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello - I'm trying to convert a table of contents in word to go into the following table in excel via VBA. Here is an example : Word table of contents: Title from Page - page 1 Quality Checks - page 1 Sounding board - page 2 Excel Document: (example output) Contents Page # Unique ID Title from Page 1 1-1 Quality Checks 1 1-2 Sounding board 2 2-1 Really need a VBA code for this if possible. Thanks in advance, Matt
Solved by K. E. in 19 mins
id like to insert a table of contents with worksheet names and page numbers. please send the vba code
Solved by E. W. in 12 mins
1. Create an Excel table named ArtHoldings, in which the contents are sorted by Location, Category, and Condition. Use a custom sort list for Condition (Excellent, Good, Fair, Poor). Turn off Filter arrows on the table.
Solved by T. J. in 24 mins
Distribute the contents of a cell into adjacent columns
Solved by A. C. in 21 mins
How can I add a cell's contents to another cell and then automatically delete the contents of the original cell?
Solved by X. D. in 27 mins