I trying to use advanced filter to copy rows with dates under "DateCreated" that are within the criteria range.
I made a test workbook where this worked fine, however when I run the filter, one of two things happens:
1) using the table name of the extract data causes the "extract range contains missing or illegal references" error message
2) using a range within the table returns all rows within that range, and not just the ones within the criteria range. A text criteria (ex. "Donna") would run correctly.
I though problem 2) was happening because of the date cell formats, which is yyyy/mm/dd h:mm, but changing the criteria to the same format hasn't helped.
Problem 1) maybe has to do with the table being linked? But even after removing the link, the same message appears.
I haven't created a macro or VBA code for the actual workbook yet, I'm just manually applying the advanced filter while trying to get it to work. Unfortunately, I can't post the actual workbook.
There's no repeat headers, though there are multiple columns with date information in the extract table.
Any ideas what might be causing either problem?