what's the correct syntax for linking between workbooks. using formula to create the necessary links. i think i have forgotten INdirect somewhere.
=FilePath&"["&A8&Xtn&"]Formula'!"&B4&"210" and i know the 210 is wrong at the end. thats actually my row number. sheet in other workbook is called "Formula" and the cell i want is at B210
=FilePath&"["&A8&Xtn&"]Formula'!"&B4&"210" and i know the 210 is wrong at the end. thats actually my row number. sheet in other workbook is called "Formula" and the cell i want is at B210