I have an excel file with two different worksheets. On the 2nd worksheet I
have a Column labled "status," in which each cell has a dropbox with either
Pre-qual, Active, or TD as choices. The other columns all have client data.
Now, I need several cells of information from the row to move to certain
cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
dropbox from the "Status" Column. Any help here would be appreciated:)

-Thanks!
-Ryan