Delete #REF rows and move rows up if it's on the first line

Hello,

I have a basketball season data workbook that I am working on and I am looking on the main page to remove rows that contain a #REF! value in the cell. However, I am looking for it to do that if a #REF! cell appears on the same row and the name of the player that I would like to clear the cell and move up the first available non-#REF! row next to the players name.

I have attached my workbook and an example of what I am trying to do is look at Matt Wenstrom on the 1993-94 Stats worksheet.

If someone can help me out with this so I don't have to manually go through and remove that would be great. Thanks in advance for your help.

Hi there,

See if the attached workbook does what you need.

It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

This is great. The only thing that I see is that it removes the Total row as well if there is a #REF! value anywhere in the row. I should've mentioned that but if possible I would like the Total row to stay regardless if there is a #REF! value or not. I don't know if it's possible but if so could you let me know how that would be done? If not it's no big deal. I really do appreciate your help with this.

Hi again,

Oops - I should have spotted that myself - sorry!

See if the attached workbook does what you need.

The code has been modified as follows to prevent deletion of the Totals rows:

Please Login or Register  to view this content.

The highlighted values can be changed to suit your own requirements.


Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

This is perfect! Thanks again for all of your help!!

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're very welcome - glad I was able to help.

Best regards,

Greg M