Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Reddkryten

macrumors 6502
Original poster
Sep 10, 2009
313
4
Hello. I have a small but irritating issue with numbers and I was wondering if anyone could offer a suggestion. Is there anyway to link two tables so they move together without overlapping/overwriting each other?

At the moment I have a spreadsheet with two tables. The top table has 20 rows of data. The second table directly beneath it summarises the above. I use a form to enter data into the first table.

This was going pretty well, until I ran into a situation where I had to add more data. In the form I hit the plus symbol, adding a few new rows and expanding the upper table.

I expected the bottom table to be moved further down, but instead it stayed in place, both tables overwriting each other.

So, is there anyway to link these two tables so they move in unison?

Thanks in advance for any help you can offer.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.