#1
|
|||
|
|||
Display multiple values as new values based on selection from template.
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. |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Need to display values with the most votes first | PatW | Excel | 1 | 02-12-2015 09:22 AM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
Insert values from multiple rows based on value in one column | pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |