Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to link cells in seperate spreadsheets without the $
I have 2 spreadsheets. For this example, lets call them A & B.
In worksheet A, I want to link to a cell in worksheet B. When I do so, added in the link is the $ before the column and row. For example, the link looks like follows : =+'c:\d&s\......\[b]Sheet1'!$A$1. I would like to to read =+'c:\d&s\......\[b]Sheet1'!A1 without having to manually erase the $ before the A and the 1. Any ideas. Thanks, Cesar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a formula to seperate name into two cells (last, . | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |