Hi, can anyone help me with this?

In one workbook, I click on a cell and type "=" . I then switch t
another workbook, click on a cell, and press

enter. What I want to happen is have a bunch of the cells in the firs
workbook automatically reference cells in

the second workbook that are next to the one I clicked on.

The cell that I click on in the second workbook is variable/not set.
Also, I don't want to have to manually drag anything; I would like i
to be automatic.

Thanks for your help

--
Message posted from http://www.ExcelForum.com