Advanced Filter Incomplete Copy to new location

**hodger1** · 11-19-2012, 07:06 PM

Hi all,

I've attached a worksheet in which I have two columns containing names of people present (don't worry they're all old), one column that is programmed to return whether or not they are absent, and the remaining two columns that are databases for all of the names of people in the organization. When I use advanced filter, specifying the list range from A5:E145, criterion range from A1-E2, and try to copy to the range J1-N145, I get the correct number of absences, but the names (much less the formatting) in the other 4 columns utterly fail to show up. How do I fix this?

If this is confusing, then an alternate way to explain it is this: Using the advanced filter (according to instructions from MS Office online) I got the result that you see in Columns J-N. They are conspicuously missing the names. How do I get the names in the 4 blank result columns?

Thanks, in Advance,

D. Hodge

**Norie** · 11-19-2012, 07:20 PM

I think the problem is with the repeated field names First Name and Last Name.

I changed the 2nd set to First Name2 and Last Name2 and ran the query.

It returned the correct results as far as I can see.