Forum Home
Press F1
Thread ID: 1412	1999-05-05 00:16:00	Excel 97 Data Filtering Macro	Guest (0)	Press F1

Post ID	Timestamp	Content	User
1770	1999-05-05 00:16:00	Via a VB macro I want to compare two lists of sorted data of one column each, comprised of labels. Both lists are the same except the second list has had new data added to it and I want to isolate the new data. This is readily done manually by <Data.Filter.AdvancedFilter> using the new list as Input data and the old list as the Criteria. The new entries in the list are extracted and used elsewhere, and the new list now overwrites the old list. VB chokes on this process, as the lists are dynamic and VB requires an exactly defined criteria range (specifying columns for the criteria does not work). Alternatively, a method of creating a Name for a dynamic range via a VB macro would help solve the problem.	Guest (0)
1