I appoligize if this question is in the wrong group. I have a workbook that
has two worksheets. On the first worksheet I have different
companyinformation in three rows which include columns with out headers. On
the second sheet I have a from that prints out the information. What I would
like to do is set the second sheet so if a row is slected on the first sheet
that information will automaticly fill in on the second sheet. My problem
appears to be that the second sheet is a form and the information is not in
the same cells on both sheets. I hope this is not as confusing to you as it
is to me.
--
Thanks

Hi
maybe VLOOKUP is what you're looking for. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Terry" schrieb im Newsbeitrag
...
I appoligize if this question is in the wrong group. I have a
workbook that
has two worksheets. On the first worksheet I have different
companyinformation in three rows which include columns with out
headers. On
the second sheet I have a from that prints out the information. What
I would
like to do is set the second sheet so if a row is slected on the
first sheet
that information will automaticly fill in on the second sheet. My
problem
appears to be that the second sheet is a form and the information is
not in
the same cells on both sheets. I hope this is not as confusing to you
as it
is to me.
--
Thanks

Frank,
Sorry for the late response, but I have been swamped with work. Thank you
very much for the information it looks like what I was looking for. Thanks
again and have a great day.

"Frank Kabel" wrote:

Hi
maybe VLOOKUP is what you're looking for. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Terry" schrieb im Newsbeitrag
...
I appoligize if this question is in the wrong group. I have a
workbook that
has two worksheets. On the first worksheet I have different
companyinformation in three rows which include columns with out
headers. On
the second sheet I have a from that prints out the information. What
I would
like to do is set the second sheet so if a row is slected on the
first sheet
that information will automaticly fill in on the second sheet. My
problem
appears to be that the second sheet is a form and the information is
not in
the same cells on both sheets. I hope this is not as confusing to you
as it
is to me.
--
Thanks