Linking Data between worksheets in a workbook
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 |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com