• 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

    Hui...

  • 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

Member
Hello,

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!
 
Sample data and mocked up solutions will help to solve this. Post a sample workbook for quicker responses.
 
Back
Top