How big is your Sheet 2 database?...........how many "PreQuals", might one
be expected to encounter......how often is this exercize performed?......is
the target area a single block, or is the data expected to populate various
cells, (such as).........
Are you just wishing to view this data or does it integrate into some kind
of a report?..........

Vaya con Dios,
Chuck, CABGx3




"ryan r" wrote in message
...
Well thanks for lookin into it:) I dont want anything to happen if one of
the other two choices is picked. I simply need data from maybe 5 or 6 of
the
12 cells in each row to be copied into the other worksheet. One of the
cells
is a number, but all others are text.

"CLR" wrote:

Hi Ryan........

I'm afraid I would need a little more information to make any kind of
specific suggestion. There are so many options toward something like
you
are taling about........ie:, linked cells, VLOOKUP formula, AutoFilter,
Macros, etc.........and you don't mention what, if anything you want to
have
happen when the selection is other than "PreQual"......

Please provide some more details and someone will be happy to
help...........

Vaya con Dios,
Chuck, CABGx3



"ryan r" wrote in message
...
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