• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to search through a list

D Coker

New Member

I am very new to VBA and would like some assistance.

I have a sheet called "Lists" with a Named Range "Required_Property" and a separate column "G" value (Sequence).
This sheet is a reference sheet.

I have another sheet called "Results" that is dynamic with a column "Property" that lists out data with a specified Property.

Based on this Property, I need each row in the "Results" sheet to have an assigned value based on column G of "Lists" sheet.

I can't seem to figure out how to do this with VBA. Any help would be greatly appreciated!


Well-Known Member
Sample data and mocked up solutions will help to solve this. Post a sample workbook for quicker responses.