I see how the drop downs are working and how to adjust the rows on the Data page to include or exclude what is in the drop down. Very nice, thanks.
I'm trying to adjust the Pivot Table now as they are not updating when I refresh. It looks like some old references are in the Pivot Table. I'm seeing if I can figure out how to change this. It's showing the investigator initials but I replaced all of them with their real names now. The Log sheet drop downs updates but not the Pivot.
|