Matching Data with Specified Criteria

I need to match data with specific criteria. Details of the problem are as follows:

I have 2 sheets: "Main" and "Sub"

In "Main" there are 3 Important Columns: Col "C", "I" and "AF"
In "Sub" there are 2 Important Columns: Col "I' and "N".

Value in column "C" of "Main" is same as value in column "I" of "Sub", but not in same order.

Now the specific criteria:

If value in Column "I" of "Main" is not equal to "Zero", then the macro should pick up the value from the corresponding column "C" of "Main" and search for the same in column "I" of "Sub". After matching the same, it should find corresponding value in column "N" of "Sub". Then the macro should pick up the value from column "N" of "Sub" and put the value in the column "AF" of "Main".

This is basic requirement.

I am unable to retrieve the right value for the same.

Fine tuining will be:

If the value in column "N" of "Sub" is "Fully Automated" then it should only write "Automated" in column "AF" of "Main". And If the value is "Manual + ...." then it should write "Manual" in column "AF" of "Main".


Can this be done??

Please help.


Thanks in advance.

A For Each Next loop, the Find method, the Range object, the Offset property and If Then Else statement are the basics of what you need; there are some examples of each in VBA help.

Hey, i tried all this.. i m not getting the desired result.. otherwise why should i write in this forum??

Hi, Can any one provide help on this?? i m really stuck on this

Hi

Can you create an example file showing your structure, some sample data, the expected output for some examples of your sample data and any code you have currently put together to date.

From what I can see, the response from T-J covered the basics of what you would need to make this work...


rylo

I will surely post some data and code for your info very shortly.

Yes TYJ has given all the basic info. but the problem is i am unable to find desired result.

I will attach a file very shortly in this forum.