Dynamically Extract Data Based On Cell Value To New Tables / Sheets

[TrentLane]

Afternoon All,

I'm trying to figure our how to extract data from an existing table and dynamically create new tables based on the data available. I'm not looking so much for an end solution but guidence in the right direction.


Here is an example table showing 12 items (however this could be as many as 200 at times):

jKYwvRS.png

As you can see above there are 4 colums; Item, Part 1, Part 2a & Part 2b.

The end goal is to extract to Word and make each dynamic table it's own page, splitting at 10 items. However to start I am trying to figure out how to dynamically extract the data with a header for each. I've manually typed up what I am trying to work towards:

B5sE6VZ.png

Any help would be appreciated.

Edit: Sample.xlsx uploaded.

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:


Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.