Forum Discussion
gracescott
Jul 27, 2022Copper Contributor
Contacts List across multiple sheets
Hi, I'm trying to make a workbook of all the contacts for a project. The workbook has a master sheet with all the contacts which people can add contacts to. Within this there is a drop-down sele...
Riny_van_Eekelen
Jul 28, 2022Platinum Contributor
gracescott Copying contact information from the Master to the individual Section sheets would require VBA. Not recommended as you say to know little about Excel. But since tagged you post with Office365,
you can use the FILTER function on each section sheet to dynamically retrieve the contact info from the Master.