Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidated/filtered list 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A list of what is being filtered on? | Excel Discussion (Misc queries) | |||
charting a filtered list | Excel Discussion (Misc queries) | |||
Top 25 in a filtered list | Excel Programming | |||
Issue with copy/paste dates from filtered data | Excel Discussion (Misc queries) | |||
pivotTable and filtered list | Excel Programming |