Correcting a #REF!

G

Guest

Good Morning:

I am receiving the error #REF!. I have a workbook with several sheets. The
summary page pulls data from each of the corresponding sheets. I have been
using Vlookup, Index, Match, etc...to retrieve the data from the detail
sheets. It works great until I delete rows from the detail sheets. Each
week we extract new data from our accounting program and convert the data to
a usable excel file. When this happens, some of the data is not needed, and
I need to delete it by row, however, the problem appears when this is done.
Any suggestions?
 
G

Guest

When you do your DELETE, you are deleting the cell location that the formula
is referring to. We may be able to assist with updating the formula so that
this doesn't occur. Please post what you have in your formula and we'll see
what we can do.
 

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

Excel Populate Delivery Note 0
GETPIVOTDATA and (blank) 0
Referencing formula using Indirect 4
Return Value from a Range (depends on input to determind month) 2
Match and delete rows on two different sheets from reference numbers 4
display first or second match instead of #REF in INDEX ROW formula 9
How Do I Avoid #REF! In Formulas? 4
lookups and sums? 1

Top