Linked cells

M

Mark

I have two spreadsheets. One has a list of names and the
other has only 4 cells, each with a link to one of the
first four names in the first spreadsheet. I would like
to print the second spreadsheet and then delete the first
four names in the first spreadsheet so that the cells in
the second spreadsheet now contain the next 4 names on
the list. When I delete the first 4 names in the first
spreadsheet, the links in the second spreadsheet fail and
I get #REF! in the cells.

I have tried both relative addressing and absolute
addressing and both return the same error when I delete
the first 4 names.

I have tried deleting the first 4 rows. I have also
tried deleting the cells A1 through A4 and moving the
remaining cells up. Both approaches result in the error.

How can I get the second spreadsheet to accept the "new"
values in cell A1 through A4 of the first spreadsheet?
 
I

icestationzbra

there is a worksheet function called INDIRECT. look it up in Help, i
might be what you are looking for to solve your problem.

if you need help, revert here, someone would surely help you on that
 
S

Seaside Mark

The INDIRECT function just return #REF! even before I
manipulate the first spreadsheet. I can't figure out how
to make the INDIRECT function work ... and I'm pretty
proficient with Excel.
 
Top