In a worksheet, to reference the information in a record format we use =record name.field name
Is there a way reference that information in a different file? Something like =path to file.record name.field name
What I'm trying to do is create a worksheet that pulls together data from the sheet borders located in multiple referenced files to create a master sheet list.