Offsetting from the Reference of a Cell, not the cell

  • Thread starter Thread starter cdegar01
  • Start date Start date
C

cdegar01

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 t
happen is have a bunch of the cells in the first workbook automaticall
reference cells in the second workbook that are next to the one
clicked on.

The cell that I click on in the second workbook is variable/not set.

Thanks for your help
 
cdegar01 > said:
Hi, can anyone help me with this?

In one workbook, I click on a cell and type "=" . I then switch to
another workbook, click on a cell, and press enter. What I want to
happen is have a bunch of the cells in the first 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.

Thanks for your help!
Click to expand...

Do you want the OFFSET function, then? For example.
=SUM(OFFSET(Sheet1!A1,0,1,2,3))
will sum the range Sheet1!B1:D2
That is, the cell range offset from Sheet1!A1 by 0 rows and 1 column, sized
2 rows high by 3 columns wide.
 
Hi

Check the freshly inserted link in first workbook, are cell references
relative - when not, then delete '$' signs.
Copy the cell with link.
Select the range you want insert links, and then Paste.
 
Hi, thanks for the reply.

In the offset function, I don't want to have to type in the cell in the
second workbook that I'm referencing. I want it to do it
automatically, based on the cell that I clicked on after I typed "=".

So basically, if this were a perfect world, I would click on a cell in
a workbook, type "=", go to the other workbook, select the cell I want,
and press enter. Then, presto! other cells in the first workbook
would reference cells in the second workbook, offset from that first
cell that I typed "=" in.

Thanks
 
I don't use quotes. I was merely doing that to show what I typed in the
cell; namely an equals sign.
 
Back
Top