Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter list in same worksheet issue
thanx! Any reason the first number in the filtered row always seem to appear twice? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORT/FILTER ISSUE | Excel Worksheet Functions | |||
advanced filter issue | Excel Discussion (Misc queries) | |||
Copying a Filter list to a new worksheet. | Excel Worksheet Functions | |||
Sort/Filter issue | Excel Worksheet Functions | |||
How to Update filter criteria from list and storing the query to another worksheet | Excel Programming |