Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking cells
I am trying to link cells from a column in workbook 1 to a column in
workbook 2. (office 2003, winxp) I choose my destination row, put the '=' in the formula bar, copy the source row, and I see the formula in the formula bar but when I hit enter I get a 0 in cell one of the destination row and nothing in any of the other cells in the row. I also tried linking a three line address from one workbook to another. If I do it one line at a time, I have success. If I try to take the 3 line address in one block and link it all at once, I get the 'Value" error. Could someone please tell me how to link more than one cell at a time between multiple workbooks. Sure would be a lot faster. I feel like there is one little thing I don't know that would solve this whole thing. Thanks for your interest and time Joanne |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking cells
Try:
=IF(Sheet1!A1<"",Sheet1!A1,"") Put this formula in the cell where you want info read into, then adjust the cell address a you need. You can then autofll ( drag the formula ) HTH "Joanne" wrote: I am trying to link cells from a column in workbook 1 to a column in workbook 2. (office 2003, winxp) I choose my destination row, put the '=' in the formula bar, copy the source row, and I see the formula in the formula bar but when I hit enter I get a 0 in cell one of the destination row and nothing in any of the other cells in the row. I also tried linking a three line address from one workbook to another. If I do it one line at a time, I have success. If I try to take the 3 line address in one block and link it all at once, I get the 'Value" error. Could someone please tell me how to link more than one cell at a time between multiple workbooks. Sure would be a lot faster. I feel like there is one little thing I don't know that would solve this whole thing. Thanks for your interest and time Joanne |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking cells
Try this:
Open source workbook(ex. SourceWorkbook), open destination workbook(ex. Destination Workbook). Destination workbook cell (ex.C2)"= Select source workbook, select source cell(ex. F22). Destination workbook cell C2 should have a formula such as: "=SourceWorkbook.Sheet1!F22" hth :-) "ufo_pilot" wrote: Try: =IF(Sheet1!A1<"",Sheet1!A1,"") Put this formula in the cell where you want info read into, then adjust the cell address a you need. You can then autofll ( drag the formula ) HTH "Joanne" wrote: I am trying to link cells from a column in workbook 1 to a column in workbook 2. (office 2003, winxp) I choose my destination row, put the '=' in the formula bar, copy the source row, and I see the formula in the formula bar but when I hit enter I get a 0 in cell one of the destination row and nothing in any of the other cells in the row. I also tried linking a three line address from one workbook to another. If I do it one line at a time, I have success. If I try to take the 3 line address in one block and link it all at once, I get the 'Value" error. Could someone please tell me how to link more than one cell at a time between multiple workbooks. Sure would be a lot faster. I feel like there is one little thing I don't know that would solve this whole thing. Thanks for your interest and time Joanne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 cells not linking | Excel Discussion (Misc queries) | |||
Linking cells from different workbooks | Excel Discussion (Misc queries) | |||
Linking cells with colors or highlights | Excel Discussion (Misc queries) | |||
Excel - linking cells | Excel Worksheet Functions | |||
linking cells colors | Excel Worksheet Functions |