Help with formula carrying down to new row in table

Hello there,

I have a table that automatically numbers the row each time I add a new row. The process I add a new row is I got to the bottom right cell (J30 in example attached) in the table and press TAB. That creates a new row. Well with that, the formula in column B gets messed up. Can someone please tell me how to fix this? I'd like it so the table rows grow as I need them, rather than having hundreds of rows blank and fill them in as we add items to our list. It's an ongoing list and prints frequently so I don't want to print blank rows.

Thanks in advance,
Lorne

That's interesting.
I have no idea 'why' that's happening.

But when I changed the formula in B2 from
=ROW(A1)
to
=ROW(B1)
OR
=ROW()-1

It works as expected.

It's somehow related to the fact that the reference (A1) was outside the scope of the Table (table seems to be B1:J30)

I can drag down the last cell B column, but I'm trying to avoid having to add that every time.

Maybe I need to start all over? Or is there a way to figure out a fix to this specific document? It used to work, it just stopped now. I think it's gotten too complicated.

Thanks,
Lorne

Originally Posted by lorne17

Or is there a way to figure out a fix to this specific document?

Did you see post #2 ?

No I didn't thanks!

Originally Posted by sandy666

Clear All with your table, set table again, put =ROW(A1) or ROW(B1), whatever...
it will work.

Attachment 441207

Forgive me, but how do I clear all with my table?

Ok so I went to my table and "Converted to Range". With that, I then recreated my Table. When I hit tab at the bottom right it still shows up with #REF in the first cell.

Not sure why it keeps doing this? The sample I gave you guys is dumbed down from my long list of items in my master, so maybe the 78 rows of notes are messing it up?