for each methods

hello..i have a qns to ask..though it might abit alittle confusing..

currently i wan to do a for method that runs from row, follow by the country, company and their groups columns..and fill in a value by its row and runs till it completes its range. but i am stuck after searching the values in rows and columns..please ignore the msgboxs as they are just for my reference that the codings are working. =)

sorry for my codes being so messy. but hope you guys can help me for my report.

attach is the sample file i have done.

Please Login or Register  to view this content.