|
|
#1
07-15-2012, 09:22 PM
|
|||
|
|||
Formula that references cell with text in different workbook
I know the formula =SUM('[3072 Wedding Fund.xls]Sheet1'!$M$3)in workbook A will retrieve the cell contents of M3 in workbook Wedding Fund.xls. The cell contents in M3 are numeric. I would also like to retrieve contents from a different cell in the same workbook Wedding Fund.xls. The content is text. I used the same formula above but the results was the forumula in the requesting workbook. What is the formula to retrieve a specific cell contents which is text from a different workbook? Thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
 Tuen off references, keep text
|
texpic | Word | 1 | 09-19-2011 07:27 PM |
|
need to check whether cell contains formula
|
etodem | Excel | 2 | 10-23-2010 07:33 PM |
|
Protect formula in cell?
|
markg2 | Excel | 4 | 05-24-2010 11:50 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows XP 
Office 2003
Threaded Mode