Good Day to all,

I'm wondering if it's possible to write a VBA or a code tat can merging diff workbook together. for example if i've a Folder call XXX in this folder there is

1.xls
2.xls
3.xls
4.xls

and the data all exist onli in columns. which means all the four .xls will join and be come 1 without duplication will be the best if not is ok.

Second question can i sort row by colour? for example if i've 10 rows of record and which have different colour can i write a code tat works like.

a loop to loop from the first to the last then
if .Cell.colour = Red then move to the bottom
if .Cell.colour = black then move to the top

Something like tat?

THanks alot to all in adv or for even reading it