I want to pull data from one sheet (Sheet 1) to another (Sheet 2). On the new sheet (Sheet 2), I want to be able to select the "Mailing Name" and have the information associated with that particular "Mailing Name" automatically pre-fill based on the data from Sheet 1. Assuming I can use a filter, the goal is to be able to select from a drop down menu any "Mailing Name" from Sheet 1 and then Sheet 2 will pre-fill based on that selection.
Then I want to auto pre-fill the corresponding data into A1, B1 and C1 also on Sheet 2, which once I can get the data there, I should be able to figure that out.
Attached is an example of the data that I'm using... PLEASE HELP!!!
Any and all help is greatly appreciated!!!
Bookmarks