Solving #REF! Problem

  • Thread starter Thread starter DMD
  • Start date Start date
D

DMD

Cell A1 is equal to cell A4.
Cells A4 thru A100 contains consecutive ascenting dates.

Each day I select Row 4 and delete that row.

My problem is that I get the #REF! error in cell A1 even though Row 4
is replaced by Row 5's data. How can I always preserve the A1 and A4
equivalency whenever I delete Row 4. This means that cell A1 has the
date that was originally in cell A5 (and is now in Row 4 when the
former Row 4 was deleted).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Printing 2
Like SUMIFS, but for multiplication?? 3
Best way to insert rows 5
Change Cell colour on click 5
Count of visible, non-blank cells only? 8
counta formula 4
How to update data from multiple sheets to one specific sheets 4
Filtering of data in a master excel sheet from multiple sheets 3

Back
Top