| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a reference to a different worksheet
Hi NJ, You have a reading in B6 of the main spreadsheet and you collect data from another spreadsheet, you transfer the data to the main spreadsheet and want to compare the two pieces of data. would something like this work? =b6-'C:\Documents and Settings\Larry\Desktop\[10.28.05.xls]Sheet1'!$B$6 Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=488374 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use a cell value to reference a worksheet name | Excel Worksheet Functions | |||
| How do I reference pictures in a worksheet? | Excel Discussion (Misc queries) | |||
| Making a file and worksheet reference into a variable.... | Excel Worksheet Functions | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
