Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference cell in other worksheet
I am trying to populate a cell in one worksheet with data from another worksheet within the same workbook. The source worksheet (sheet 1) has a numbered column (Column A) but the numbers do not necessarily match the cell’s row numbers. The data I want to capture from the source is in column Q. The destination worksheet will have a column (column A also) with the number of the row from the source worksheet from which I want to capture column Q data and place it into column B (on sheet 2). Code: -------------------- Sheet 1 (source data) Row A Q 1 1 Data point 1 2 2 Data point 2 3 3a Data point 3 4 3b Data point 4 5 4 Data point 5 Sheet 2 (need to populate row B with data from sheet 1 based on the information in Row A) Row A B 1 3a 2 4 3 2 4 1 5 3b -------------------- -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=492759 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference cell in other worksheet
In sheet2 B1
=VLOOKUP(A1,Sheet1!$A$1:$B$5,2,FALSE) -- Ian -- "JimDandy" wrote in message ... I am trying to populate a cell in one worksheet with data from another worksheet within the same workbook. The source worksheet (sheet 1) has a numbered column (Column A) but the numbers do not necessarily match the cell's row numbers. The data I want to capture from the source is in column Q. The destination worksheet will have a column (column A also) with the number of the row from the source worksheet from which I want to capture column Q data and place it into column B (on sheet 2). Code: -------------------- Sheet 1 (source data) Row A Q 1 1 Data point 1 2 2 Data point 2 3 3a Data point 3 4 3b Data point 4 5 4 Data point 5 Sheet 2 (need to populate row B with data from sheet 1 based on the information in Row A) Row A B 1 3a 2 4 3 2 4 1 5 3b -------------------- -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=492759 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference cell in other worksheet
This is exactly what I need if the reference column and the data are in adjacent columns. Is it possible to do this if the reference data is in Column A and the data I’m trying to capture are not adjacent to each other such as column Q? -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=492759 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference cell in other worksheet
Okay, after pulling my head out I realised that I need only study the function better and I was able to answer the question myself. I thank you Ian for the head start. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=492759 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference cell in other worksheet
Sorry for the delay. I've been offline for a few days. Glad you managed to
sort it out. -- Ian -- "JimDandy" wrote in message ... Okay, after pulling my head out I realised that I need only study the function better and I was able to answer the question myself. I thank you Ian for the head start. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=492759 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a cell on another worksheet in the same spreadsheet file | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |