Search multiple Excel Workbooks and get data

[redahussien]

HI,

I need a help to search two or more excel workbooks Data1,Data2
and get the result in the fetchData workbook.

how can this be achieved by vba , to search the data1 first if not found go and search in data2.
if found it will go to another entry in the fetchdata file and do the same.

all the files are in the same folder.


sample files attached with a simple entries.

thanks in advance.

[achammar]

Try this:

Put this workbook in the same folder as your data files and run the macro. It will check the first sheet of every .xlsx file in that folder for data and put it where you want it if I understand you right. I did not test it very much, but it worked for me with the data files you attached..
It is very range specific so you won't be able to change your starting rows or columns in the data files or this file.

[jindon]

try

Please Login or Register  to view this content.

[redahussien]

thanks for reply,
this will search data1 first for all values , if the first value (in column A) exists in the data2 it will not search the next values in data1.
hope you got my point.

[jindon]

That's what the code does.

Any problem?

[redahussien]

@jindon @achammar

if you try both of the codes on the same data attached you will understand my problem.


if i put 5 for example in the top of the column it will fetch the data
if at the end it will not fetch the data.

[jindon]

Absolutely no idea about what you are trying to do and the files you uploaded.