I have 5 lists showing business contacts. Each list is its own sheet from an separate individual. I want to have the ability for them to include only selected contacts into a separate summary sheet. In the past I have built a "on/off" switch by allowing users to place a "1" in a cell and then using an "ifs" function and vlookup to gather data. I have never had that data coming from different sheets onto a single summary list.
Does anyone know a function/process to do such a thing? The goal is a single summarize and sorted list of contacts. Thanks!
Does anyone know a function/process to do such a thing? The goal is a single summarize and sorted list of contacts. Thanks!
