find and search in vb macro

[webmax]

i have the below heading in the multiple workbook.


i want to open the each workbook and first search emp code if yes they copy the below data again go to the same workbook sheets which contains data and search emp name.


I want the macro code if i search Emp code the data is not there it will go to next data and search Emp Name.


Emp Code Emp Name

 

[SirJB7]

Hi, webmax!


Please clarify these points:

a) How many workbooks do you have?

b) Where are they located (folder)?

c) Do they have any pattern naming convention?

d) Where do you obtain the EmpCode for performing the search?

e) How is the "below data" structured?

f) Where do you want to copy it to?

g) How do you identify that "the data is not there"?

h) What is "next data" referring to?


Well, I thought I had a couple of questions when I began to write this post but it seems as if either I didn't understand anything or you haven't been clear enough.


Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.


Regards!