Need to merge multiple excel files into one master-worksheet with conditions

[Rishu Mehra]

Hi Excel-pros,

I've 6 excel files with me that shows the data of subscribed and un-subscribed users of my blog. Now I need to merge all-of-them into one worksheet and also need to remove duplicates from it. Plus, need to automate a condition, if any of the email-id is in my any unsuscribed list/file it should say 'no' in a column in master-worksheet and 'yes' for the subscribed list/file.

Can someone please share their inputs and help me in 'how-to' task for it.

Any help will be highly appreciated.



Cheers,
Rishu Mehra

 

[vletm]

@Rishu Mehra would You get only written solution
or
if You could upload one sample of those file and needed out put
then You would get something suitable.
Without sample file ...
would You 100% 99% happy with offered solution
(that You won't need to modify it for You needs)?

 

[Chihiro]

What version of Excel do you have? If you have Excel 2010 or versions with access to PowerQuery. It's just the tool for it.

But as vletm wrote, you'll need to upload sample workbook(s) to get help.