I have two Excel worksheets (named "Bid Summary" & "Data"). I have a list validation option in "Column A Row 1" in the "Bid Summary" sheet. When I select a name in the list, I want "Column B Row 1" to update with the corresponding information from the "Data" sheet. e.g. - if I select "Blue" in the list validation column, I want the other column to pull all information related to "Blue" in the "Data" sheet...say "Red & Green." To do this will require a loop/if statement. Something that probably won't be too difficult.
Complete and fully-functional subs for Visual Basic with generic column & row references that I can modify to fit my exact needs. Complete source code of all work done.
## Deadline information