copy items into column across files and copy to bottom with ignore duplicate items

[Hasson]

hi
the result should be in file RESULT . should create whole data with headers . the idea should bring all of the items from all files from column B but should not bring duplicate items if there are existed across files . every time should copy to the bottom when bring different items from multiple files with ignore the duplicate items .
thanks

[kvsrinivasamurthy]

Code for macro.
NOTE: Give correct path for both the files.

Please Login or Register  to view this content.

[Hasson]

thanks but there are some items don't show . I highlighted in column G some items are missed , also it deletes the borders and formatting when every time run the macro even if I do the formatting and borders manually the macro delete it .

[CheeseSandwich]

If it is not a massive list then amybe bring in all data and then remove duplicates?

Please Login or Register  to view this content.

[kvsrinivasamurthy]

I have corrected mistakes. Formatting portion is removed. Whatever you have set remains.

Please Login or Register  to view this content.

[Hasson]

@CheeseSandwich actually I attached simple data to understand my requirement . but I excpect to reach the data about 800 rows for each file
so the question is " does your code works with about 1000 rows for each file?

[Hasson]

@kvsrinivasamurthy thanks again , but still problem continues about borders and formatting . the code doesn't make it and delete it if I make it manually .

[CheeseSandwich]

Yes should be fine with that - the code will expand its range depending on the data in the pecified files.

[Hasson]

@CheeseSandwich so I will test it and inform you how works for me .

[Hasson]

@CheeseSandwich your code works very well , but I need your help .
first I would expand the files maybe I have more than two file I would use directory contains many files instead of specify two files
second I would sort the items from small to big for the letters , numbers to become more arranging .

[CheeseSandwich]

You want to sort by column B at the end?

Please Login or Register  to view this content.

Path is the folder where your files reside

[kvsrinivasamurthy]

Try this code

Please Login or Register  to view this content.

[Hasson]

@CheeseSandwich I would ask you if there is way make the file which run the macro from it "RESULT" also it's in the same folder becuase it delete your macro and doesn't work if I put it in the same folder.

[Hasson]

@kvsrinivasamurthy nice work ! I don't waste your time if you still interest , may you see post#10,please ?

[kvsrinivasamurthy]

Code for macro.
In the code;
Number files to be entered (FilesNo). I have given 2
Enter all file names .

Please Login or Register  to view this content.

[kvsrinivasamurthy]

A faster code

Please Login or Register  to view this content.

[CheeseSandwich]

Name the workbook: Result.xlsm and put the below code in it. Put it in the folders with all of the files you wish to import and run it.

Please Login or Register  to view this content.

[Hasson]

all of things are great !
many thanks guys for your time and help .

[jindon]

Different method.

Please Login or Register  to view this content.

[Hasson]

@jindon this is very excellent ! just it misses the sort from small to big as in codes of the others guys
thanks very much

[jindon]

Are you happy with such sort?
Built in Sort function can not sort as you mentioned in Expected result.

This gets a little slow compared to my original, but if you like it to.

Please Login or Register  to view this content.

[Hasson]

@jindon this is very impressive for this great work .
thanks so much

[Hasson]

my apologies experts! it's possible summing duplicate items in column C in file RESULT based on your codes in post#16 or 17 or 21,please ?
especially post#21 I like it .
thanks again

[jindon]

Replace "test" & "mysort" sub procedure with below and other 2 functions must stay intact.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Hasson]

@jindon I appreciate your fast answering and thanks for your updating.
just I have note . the code becomes slow. it gives running speed about 0.510 .is it normal or becuase of my PC?

[jindon]

I don't know how many workbooks you are dealing with and formatting, special sort etc.
If you are saying it is slow, ask someone esle.

[Hasson]

I don't know how many workbooks you are dealing with and formatting, special sort etc.

the same attached files as in OP.

If you are saying it is slow, ask someone esle.

no ! just I consult you may be you have idea about this case .