Copy the cell from the source workbook and Paste Special-Paste Link in a
cell of destination sheet
You will get a formula like
=[Book1]Sheet1!$A$1

"soconfused" wrote:

I have two distinctly different workbooks. I am trying to grab information
from one workbook and enter it into another. I need the workbook B to look
for the information in workbook A and enter it into specific columns. Is
there a formula I can use?

Thanks
--
DMM