Hi,
I am trying to use the advanced filter tool to paste 'uniqe records only'. I do not however want to include the column headings in the 'list range'. If I don't include these headings in the range, when I 'paste to another location'I get an error message "the extract range has a missing or illegal filed name". Is there any way around this pls??
I am trying to use the advanced filter tool to paste 'uniqe records only'. I do not however want to include the column headings in the 'list range'. If I don't include these headings in the range, when I 'paste to another location'I get an error message "the extract range has a missing or illegal filed name". Is there any way around this pls??