Filter list in same worksheet issue
 

I need to filter a list from one place on the worksheet to another
place.
I cannot use the advance filter method as there is other supporting
information that I dont need to altered in anyway. Advance filter
seems to hide these rows which alters the other data on the sheet.

I've spend days creating a code to copy the list, create another
temporary sheet, paste the data, delete duplicates, copy that
(filtered) data, then paste it on the original sheet, then delete the
temporary sheet.

However, this has got to be the longest, most complicated and
troublesome route ever!

Any suggestions that could help?
Main goal is to create a consolidated list (filtered / with no
duplicates) in another row while leaving the original list as is.

Data to copy and filter out the dupes :
L13:L250

Desired location for consolidated list (filtered / with no
duplicates).
Q13:Q250

Filter list in same worksheet issue
 

Hi

Try this:

Range("L13:L250").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Range("Q13"), Unique:=True

Regards,
Per

"J.W. Aldridge" wrote:

I need to filter a list from one place on the worksheet to another
place.
I cannot use the advance filter method as there is other supporting
information that I dont need to altered in anyway. Advance filter
seems to hide these rows which alters the other data on the sheet.

I've spend days creating a code to copy the list, create another
temporary sheet, paste the data, delete duplicates, copy that
(filtered) data, then paste it on the original sheet, then delete the
temporary sheet.

However, this has got to be the longest, most complicated and
troublesome route ever!

Any suggestions that could help?
Main goal is to create a consolidated list (filtered / with no
duplicates) in another row while leaving the original list as is.

Data to copy and filter out the dupes :
L13:L250

Desired location for consolidated list (filtered / with no
duplicates).
Q13:Q250

Filter list in same worksheet issue
 

thanx!

Any reason the first number in the filtered row always seem to appear
twice?

Filter list in same worksheet issue
 

Hi

Thanks for your reply.

On 28 Okt., 22:31, "J.W. Aldridge"
wrote:
thanx!

Any reason the first number in the filtered row always seem to appear
twice?

The filter function see the first row as a header row. If you have a
header in L12, you could expand your filter range to include the
header. Just notice it will copy the header to the destination too.

Regards,
Per