Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Unique Data Only!
Hi everyone.
I have multiple excel file reports saved under C:\My Docs\. Each reports contain large amount of data and even though its in the same format everymonth, data changes. 1. Column H:H in all the reports contains 3 letter + 2 number digit code. e.g. DTF01, COF01 etc 2. There are multiple of those codes in column H:H quite many of them repeating so I just do an advanced filter - unique records only to pull up the unique ones. 3. Every report has those codes in column H:H and they are different in numbers, different in code. What I did in VBA is just to open up each file automatically, copy column H:H then paste into new workbook column A:A. Once it did that for all the reports, it performs advanced filter - unique records only then pastes in to column B:B. I can achieve the end result by doing this however I found this extremly not efficient. Is there any other way to extract unique records only from column H:H for all the reports combined? Thank you for your help in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
etract unique data from multiple workbooks after extracting data | Excel Programming | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Automate unique data to move to unique worksheets | Excel Programming | |||
data reduction--goal:unique time data only | Excel Programming |