Do a quick check on the top-line formulas (those in I2,A2,B2,...) to ensure
that these are intact and exactly* as per my response. Re-fill all of them
down. Are the results okay now?
*check especially that its "ROWS($1:1)" everywhere, not "ROWS(1:1)" as Excel
sometimes has a habit of removing the dollar sign when you press ENTER to
confirm the formula (when it detects/suggests closure for missing parens)

Also, in general, do not *delete* rows in updating data. Deletion of rows
may mess up formulas elsewhere. Just clear the old data range (use the Delete
key to clear contents), then either input/paste special as values.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tina Hane" wrote:
Max:
Thank you for the formulas! I put the formaulas in and got them to work
for the first 13 lines. After that, I still get the quantity and part
number, but the description and cost show #REF! The app. tells me I have an
invalid cell reference error, though the cells are copied all the way down.
I can recopy and clear some, but there are some that will not clear doing
that. Any ideas on what might be wrong? Thanks again for helping with this!
Tina