Link cell from Wkbk1 to a cell in a specific Worksht in Wkbk2
=[Reports.\xls]ERS!$B$1
--
KM
"Eric G" wrote:
What does the formula look like? Can you copy it and paste it here so I can
see it?
"Kelly M" wrote:
Thanks Eric-
I have both workbooks open and performed the task that you indicated. When
I select the cell from workbook 1 after performing the actions you provided,
I can see the formula that was created but it is not linking to the new
workbook's worksheet?
--
KM
|