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.
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.