I am trying to reference a cell in a closed workbook from a date in an open workbook. The closed file name is based on a date such as Mnly0106.xls for January 2006 data. What is the best way of referencing cells in closed workbooks?
I am trying to reference a cell in a closed workbook from a date in an open workbook. The closed file name is based on a date such as Mnly0106.xls for January 2006 data. What is the best way of referencing cells in closed workbooks?
=[Mnly0106.xls]Sheet1!$A$1
Change Sheet and cell names as needed.........
Vaya con Dios,
Chuck, CABGx3
"sastefan" wrote:
>
> I am trying to reference a cell in a closed workbook from a date in an
> open workbook. The closed file name is based on a date such as
> Mnly0106.xls for January 2006 data. What is the best way of
> referencing cells in closed workbooks?
>
>
> --
> sastefan
> ------------------------------------------------------------------------
> sastefan's Profile: http://www.excelforum.com/member.php...o&userid=32039
> View this thread: http://www.excelforum.com/showthread...hreadid=517872
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks