When you use another workbook, the cell uses absolute references.

You see $a$1 instead of just a1. After you finish with the first cell, change
that reference to relative reference ($a$1 to a1) and then drag across.



Fran McConville wrote:

Oh...if only it were that simple Max! That certainly works within a
worsheet, and within a workbook from one sheet to another, but it doesn't
work from one workbook to another. Don't ask me why!!

-Fran

--

Dave Peterson