Hey, Batman1! Thanks for helping out with this, I really appreciate it



This example is strictly the template (and example) for this workbook. I created 10 blank rows under each Title row simply for data uniformity during testing and then blanked each row to create a sanitized example to post here.

The number of titles in Column B will (only) increase depending on the number of manuals created as the project moves forward.

The number, composition, and details of chapters for each manual created (Columns C~H) should (only) increase depending on the number of manual chapters created as the project moves forward.

e.g., There can be Manuals with anywhere from many to just a few Chapters.

Again, I had been looking for a solution to this for a while, and there are now several workbooks the company wanted created using the same 'titled blocks of data' method.

I will try this with your formulas now!

Thanks, again! I'll let you know how it goes!