Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting to specific cells in Excel
I have successfully established a link between two cells of two different
workbooks in Excel. I need to be able to just copy and paste in order to change my source data when I am updating my figures. When I copy and paste the new sheet into my source sheet, the linked cell shows "0" instead of the updated number. Is there a way I can prevent this from happening or can I create a data connection for one cell in particular? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting to specific cells in Excel
You end up with a formula that looks like:
=[book2.xls]Sheet1!$A$1 You can modify this formula to hide the 0. =if([book2.xls]Sheet1!$A$1="","",[book2.xls]Sheet1!$A$1) (the formula will include the path if the "sending" workbook is closed.) Stonewall wrote: I have successfully established a link between two cells of two different workbooks in Excel. I need to be able to just copy and paste in order to change my source data when I am updating my figures. When I copy and paste the new sheet into my source sheet, the linked cell shows "0" instead of the updated number. Is there a way I can prevent this from happening or can I create a data connection for one cell in particular? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
connecting wordpad and excel | Excel Discussion (Misc queries) | |||
connecting multiple cells to new sheet (VLOOKUP?IF?) | Excel Worksheet Functions | |||
hide specific cells in Excel | Excel Worksheet Functions | |||
Connecting a form to an Excel workbook... | Excel Discussion (Misc queries) | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) |