Or, if you don't like to type, try it this way:

Open both files with Workbook #2 active, click cell A2 & type =

Go to WindowWorkbook #1 (or click the taskbar button), click cell A2 &
press Ctrl+Enter (this finishes your formula & leaves A2 as your active cell).

Use the Fill Handle to copy right or down (one direction at a time), then
fill in the other direction.

Suggestion- read up on "Links to other Workbooks" because there are a number
of considerations to know about.

Hope this is useful |:)

"KG" wrote:

Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can I
point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook #2?