I have Sheet_1 with data filters applied to range A1:D1. I want to write
code that goes across each of these columns to determine if the filter has
been set or not. If a filter HAS been set, I want the code to Copy/Paste the
values in that column to the same cell on Sheet_2. If a filter HAS NOT been
set for that column, I want the corresponding cell on Sheet_2 to show the
word "ALL".

For example, here is how the table on Sheet_2 might look if the user had set
filters for columns A & C, but not B or D:

A1 B1 C1 D1
--- --- ---- ----
Sales ALL Fargo ALL
Mktg