drewloveland
12-08-2008, 05:13 PM
Hi,
I need some help on a macro that will make a list of unique names on one worksheet from data on 3 other worksheets. I've attached a sensitive-information-removed version of my file to this post. Basically, I need to create a list of unique names on the "Individuals" tab under the "Developer / Engineer" column. The source data would be all persons listed under column D on the other 3 sheets: "Assigned," "Closed," and "Open." I figured out how to do this using the Advanced Filter, but I can only get it to work using the data from 1 sheet. I'm not sure how to automate this so it can grab the data from all 3 without overwriting anything. I can't just consolidate the 3 sheets as it would mess up my formulas on the summary "Individuals" tab. Any help would be appreciated.
Thanks
I need some help on a macro that will make a list of unique names on one worksheet from data on 3 other worksheets. I've attached a sensitive-information-removed version of my file to this post. Basically, I need to create a list of unique names on the "Individuals" tab under the "Developer / Engineer" column. The source data would be all persons listed under column D on the other 3 sheets: "Assigned," "Closed," and "Open." I figured out how to do this using the Advanced Filter, but I can only get it to work using the data from 1 sheet. I'm not sure how to automate this so it can grab the data from all 3 without overwriting anything. I can't just consolidate the 3 sheets as it would mess up my formulas on the summary "Individuals" tab. Any help would be appreciated.
Thanks