Cannot eliminate Value Error

[ravenbird]

Hello, I am trying to update a person's finances for this past year. She sent me a workbook that has two sheets with macros. The first sheet is linked to the 2nd. When a name and number is typed into the first sheet it automatically shows up on the 2nd.

My problem is, no matter what number I change on the first sheet under amount, the Total cell on the 2nd sheet gives me the #Value error. I have not changed anything, have not deleted any formulas but no matter what I do, that value error always shows up. I know very little about excel but I thought I knew enough to be able to update this book for her. Is there a special way I should be inputting the numbers on the first sheet so that the value error will show the running total instead of an error?

Thanks in advance.

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

[shg]

I think we'd need to see the workbook to help. Can you remove the sensitive date (but include at least some dummy data) and post the workbook?

[JBeaucaire]

The cell with the error...what is the formula in that cell?

[ravenbird]

This is the formula for the Value error =SUBTOTAL(109,$D$5:$D$30000)

[ravenbird]

Here is a copy of the report with the names and such removed. The Error is on page two but is generated when I change a number on page 1.

[NBVC]

What version of Excel are you running?

The 109 code doesn't work on earlier than 2003.

Try instead: =SUBTOTAL(9,$D$5:$D$30000)

[ravenbird]

2002, I don't use it much but I will try that. Thank you.

[ravenbird]

I think that did it!! Thank you so much. I have been trying to find a fix for this all day long. Much appreciated!