deleting rows without losing reference?

[onlysubime]

Hi, I created a spreadsheet that has multiple sheets. One sheet is for data entry. there is another sheet that is a print view. the print view references the data entry sheet.

for example:
the INPUT Patient List sheet has the entry of "Winnie Hoang" at cell D7
the PRINT view sheet at cell D7 has the entry of ='INPUT Patient List'!D7

So the print view is supposed to be a near mirror of the INPUT sheet. The print view sheet is more properly formatted to be printed and excludes some columns that the data entry sheet has.

So the staff will not clear the row (or hit the delete key) but will rather delete the row because they don't want to leave gaps in the spreadsheet. But I think this is what's causing problems for the print view sheet because the cell is being deleted rather than cleared.

How can I solve this problem?

[Phuocam]

Try this

=INDIRECT("'INPUT Patient List'!D7")

[onlysubime]

INDIRECT is for text strings? does it work with dates and other data types?

[Phuocam]

Try entering numbers or dates in D7, see the result of the formula