vlookup...transferring info from 1 sheet to another....
 

i hope im explaining this correctly... i have 3 sheets within my workbook...
presently ive got 2 set up with a vlookup... worksheet #1 is the primary
where all the info end's up... #2 has the list's on them... im trying to get
the results from sheet #1 to the new one which is#3...
#1 is a prequal form for my clients
#2 has the list's on them
#3 is an actual submission form to be turned in to my office staff

ive already gone in an linked up some other info with =sum and then the
cell- but that was info that had been manually inputted initially....

trey

Your information is pretty vague, but this formula in, say, cell K3 of Sheet3,
will retrieve the information from Sheet1!B5 =Sheet1!B5



On Wed, 2 Feb 2005 20:09:01 -0800, "trey braid"
wrote:

i hope im explaining this correctly... i have 3 sheets within my workbook...
presently ive got 2 set up with a vlookup... worksheet #1 is the primary
where all the info end's up... #2 has the list's on them... im trying to get
the results from sheet #1 to the new one which is#3...
#1 is a prequal form for my clients
#2 has the list's on them
#3 is an actual submission form to be turned in to my office staff

ive already gone in an linked up some other info with =sum and then the
cell- but that was info that had been manually inputted initially....

trey

that didnt work...i got a name error... this is what im trying to do... my
prequal-sheet1 has a vlookup to sheet2 which has a list of all my clients...
once the client is chosen i want that choice to be transferred automatically
to sheet 3 which is my submittal form... i hope this make's it a little
cleared what im trying to do...
thanks
trey

"Myrna Larson" wrote:

Your information is pretty vague, but this formula in, say, cell K3 of Sheet3,
will retrieve the information from Sheet1!B5 =Sheet1!B5



On Wed, 2 Feb 2005 20:09:01 -0800, "trey braid"
wrote:

i hope im explaining this correctly... i have 3 sheets within my workbook...
presently ive got 2 set up with a vlookup... worksheet #1 is the primary
where all the info end's up... #2 has the list's on them... im trying to get
the results from sheet #1 to the new one which is#3...
#1 is a prequal form for my clients
#2 has the list's on them
#3 is an actual submission form to be turned in to my office staff

ive already gone in an linked up some other info with =sum and then the
cell- but that was info that had been manually inputted initially....

trey

Hey Trey!

What Myrna suggested should work.

Did you replace "Sheet1" with the actual sheet name?

Or better yet, just select the cell on "sheet3" and enter
= then navigate to "sheet1" and select the target cell
with your mouse. Then hit enter or click the
green "checkmark" to the left of the formula bar.

Biff

-----Original Message-----
that didnt work...i got a name error... this is what im
trying to do... my
prequal-sheet1 has a vlookup to sheet2 which has a list
of all my clients...
once the client is chosen i want that choice to be
transferred automatically
to sheet 3 which is my submittal form... i hope this
make's it a little
cleared what im trying to do...
thanks
trey

"Myrna Larson" wrote:

Your information is pretty vague, but this formula in,
say, cell K3 of Sheet3,
will retrieve the information from Sheet1!B5 =Sheet1!B5



On Wed, 2 Feb 2005 20:09:01 -0800, "trey braid"
wrote:

i hope im explaining this correctly... i have 3 sheets
within my workbook...
presently ive got 2 set up with a vlookup... worksheet
#1 is the primary
where all the info end's up... #2 has the list's on
them... im trying to get
the results from sheet #1 to the new one which is#3...
#1 is a prequal form for my clients
#2 has the list's on them
#3 is an actual submission form to be turned in to my
office staff

ive already gone in an linked up some other info with
=sum and then the
cell- but that was info that had been manually
inputted initially....

trey


.