I have the following case:
Worksheet2: I have 3 columns in Worksheet2
- Sales Account Name
- Sales Rep No.
- Sales Level 6 Name
Worksheet1:
I have 3 columns in worsheet1
- ERP/Segment1
- Misc6
- Misc7
My aim here is to read each line from worksheet1 and look for matching values from ERP/Segment1 开发者_JAVA技巧matching Sales Account Name from worsheet2 and insert the Sales Level 6 Name in Misc6. Can someone help please.
You might like to read Excel VBA to match and line up rows
Why can't you use a VLookup - Do you need to insert multiple Sales Account names into the Misc6 column?
Can you post an example of your data?
精彩评论