Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

#REF!

Posted by Amy Wheeler on September 19, 2001 11:47 AM

I paste linked from a master spreadsheet to a source; however if I delete a row from the master spreadsheet, the source spreadsheet provides a #REF! since the reference is missing. Is there a way to delete a row from the source and have the same row deleted from the destination.

(i.e. I want to eliminate Jane Doe from my source since she is now terminated. How can I remove her information from the destination (without a #REF! error?)

Thanks! I appreciate all of your help in Excel!!!

This is a hack answer, but maybe it will help until something better comes along

Posted by Eric on September 20, 2001 5:03 AM

You could set autofilter on your linked spreadsheet and set it to custom filter, and set it to "does not equal" and "#ref!"
you would have to rerun the filter each time you deleted a source row in the master spreadsheet though.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.