lookup values using VBA codes

Hi

im not a master in vba codings and i am having a hard time on how to get for this code.

i have attached the template and from summary tab, users are needed to enter their CIM ID and once the user enter their CIM, all campaigns are listed underneath and
it will based it all under Data Tab.

Perhaps something like this?

You fill in CIM ID in cell B2 "Symmary" sheet and when you press enter you get the updatred result. As it was not clear to me how you wanted the result to be you are getting all values i.e. A to C. This can be modified of cource.

Alf

yes something like that but sir it is not working

Try the attached.

Another:

Please Login or Register  to view this content.