MS Excel 2013:


I have a spreadsheet with subject (module) examination details that are used for a Mail Merge document. The subjects are listed in a template from "Module 1" to "Module 8" respectively, each with its own consequent date, duration and time values. This template is used to inform students of their applicable examination dates, duration, times, venues and invigilator details.

The problem starts when students have to write a second opportunity.
When the subjects are marked with an “X”, I require the information to be displayed in a new table as per example provided (This is also required to accommodate a second Mail Merge, but is not the primary objective here).
I have no idea how to go about in achieving this.

Any assistance shall be greatly valued.

Attached Images

Modules.png (21.3 KB, 15 views)

Could you please provide a sample sheet ( pics are useless to work with). Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

From what I can make out from your pic, all you need is to filter the data on column B. A mailmerge can likewise filter data, so I doubt you'll need a separate table for that, either.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]