View Single Post
 
Old 09-04-2023, 03:03 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

In Excel you would add filter buttons at the top by making it a table (aka ListObject) and filter by name.

To set up a mail merge where each person gets a list of their results using this source info, you would need to set up a more complicated merge which is known as a 'Many to One' merge. This tool by Graham Mayor should provide assistance for doing that - Merge Many To One
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote