Deleting data from an excel file without loosing cell references

[farmertml]

Hi, I don't want people to think I'm a huge forum spammer at the moment but having lots of problems with my spreadsheet.

I have entered some data incorrectly into WorksheetA (about 10 rows worth) and I want to delete it and move the other data up. The problem I have is that in a second worksheet "WorksheetB" which refers to cells in the originall worksheet.

Is there anyway to remove the rows of data without breaking the formulai in Worksheet B.

The formulas in WorksheetB are

=IF('WorksheetA'!H21=0,"",'WorksheetA'!H21) <--- the main one which breaks.

=IF(ISERROR($L22),"",($L22))


Regards,
Paul

 

[Andrew Poulsom]

Couldn't you copy/paste the data then clear the cells containing duplicates at the bottom?