| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet name
Hello everyone, I have a problem, i have a formula in one worksheet wich gets data from another excel file: =+'C:test.xls]Worksheet1'!A8 The worksheets in the two files are exactly the same so my question is can i replace Worksheet1 in the above formula so he takes the current worksheetname of the current worksheet-file? Kind regards, Borrie -- borrie ------------------------------------------------------------------------ borrie's Profile: http://www.excelforum.com/member.php...o&userid=37717 View this thread: http://www.excelforum.com/showthread...hreadid=573045 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet not showing up in VBE | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
