Hi Angela,

Is there any reason you can't just create a pivot table from the data in
your Communications Log and put it in your Issues Log workbook with a page
filter for Column A = Yes? You can select all the way down to the bottom of
your Communications Log worksheet even if there's no data in the bottom rows
in order to make sure you're always picking up new data if your
Communications Log expands every day, month, etc. Then all you'd have to do
is refresh your pivot table in the Issues Log whenever you wanted the new
Yes's to show up. You can even write a really quick line of VBA code that
would update that pivot whenever a user opened the Issues Log.