G
gferrer010
I continuously update a database - it has multiple columns - and have
assigned a dynamic range name to it ("List"). Since the database has
some duplicate records, very often I end up performing the Data/
Filter/Advanced Filter routine and copying the unique records onto
another sheet (same workbook).
Would it be possible to automate this command? Is there a macro that
would copy the unique records to another sheet automatically, while
the workbook is open, without having to push a command button, or
opening/closing the file? Thanks in advance.
Regards,
George Ferrer
assigned a dynamic range name to it ("List"). Since the database has
some duplicate records, very often I end up performing the Data/
Filter/Advanced Filter routine and copying the unique records onto
another sheet (same workbook).
Would it be possible to automate this command? Is there a macro that
would copy the unique records to another sheet automatically, while
the workbook is open, without having to push a command button, or
opening/closing the file? Thanks in advance.
Regards,
George Ferrer