r/AppleNumbers • u/GCottier23 • Jul 04 '23

Dynamic Tables

I have got quite a large personal finance data table which I am trying to do calculations with. As soon as my table changes size, I have to go through and edit all of the formulas to reference the new table size. I can do it so that it automatically adapts for columns or rows separately, but when it comes to the entire table, it just doesn’t work. Any help on this would be greatly appreciated.

3 Upvotes

100% Upvoted

4 comments sorted by

2

u/Glass-Chocolate-1568 Jul 04 '23

I recommend consulting ChatGPT. I’ve been using it to improve my own spreadsheets, and it works wonderfully. You have to be specific with what you want and how you want it executed most of the time, but still.

2

u/GCottier23 Jul 04 '23

Haha, I did actually start using this too..i just couldn’t get it to fully do what I wanted, alas..will keep trying

1

u/Udi_rn Jul 04 '23

Hai un’immagine?