Hi there, I am developing a Prospect Database for work that many of my co-workers will be using for sales. I have created a Work Book that have 5 sheets total. The first sheet is the Master List containing a list of all of the prospects information on one page. Column 'A' will be used to assign each prospect a number 1 - 4 which we will be using to rank them in order of priority. I have already created a drop down box that will allow my co-workers to select the options 1 - 4. Each sheet after the Master list will be listed Rank1, Rank2, Rank3, and Rank4. So... here is my question... How can I make it so that once the options 1 - 4 have been selected from the drop down the data for the prospect will then auto populate into the corresponding sheet? FOR EXAM: 4Rx10 SHEET 1(the first set of data feilds) I have chosen to Rank my first propect with a 2 from the drop down box. Now the information for my prospect will auto populate in my Sheet 3 titled "Rank 2".