Ask Your Question

How do you code your record counter to connect to the previous page or next?

asked 2019-11-17 07:00:27 +0100

BillR gravatar image

I've made a spreadsheet using multiple blocks which I call an individual record. My sheet has 100 records per sheet. My counter in each record counts up or down with adds or subtracts from the records. But when a sheet is full and I move to the next page how do I code to the last cell of the previous page so that the count continues?

edit retag flag offensive close merge delete


I am still having a problem with linking my record count page to page. If my 1st page is named Sheet1 then per theory this reference to sheet1’s last cell which is ( BE389 ) should be =Sheet1.BE389+1. This is not working unless I change the +1 to 101 then it works but it is ignoring the 1st sheet in effect.

BillR gravatar imageBillR ( 2019-11-18 16:19:03 +0100 )edit

Update ... I was doing some cosmetic reformatting of my records, during this the last record cell ( which is key ) was removed then re-pasted... and NOW this =Sheet1.BE389+1 now works. I'm not sure why this didn't work before but just happy to move on to whatever the next problem will be.

BillR gravatar imageBillR ( 2019-11-18 17:19:51 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-11-17 08:51:11 +0100

ebot gravatar image

I hope I understood your request correctly. For example, in Table1, the last record counter in A100 is 100. Then, in Table2, you write in A1, "= Table1.A100 + 1" (without the quotation marks).

image description

I hope it helps you.

If my answer has solved your problem, please click on the checkmark in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1909; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-11-17 08:52:03 +0100 )edit

answered 2019-11-25 15:17:32 +0100

BillR gravatar image

After an extreme amount of testing I've gotten much of my project to work. I have identified some work principles that I have made into rules for myself. (1)-- WORK ON COPIES!! (2)-- Create your spreadsheet with enough "space" around it for adjustments as you develop your project. Meaning start at C10 or another such random number easy to remember and identify that "weird" things are not warping your design!! (3)-- When you design your "FORM" put the start at your "C10" or what you choose then record the end cell which in my case is "BE394". This makes an easy check on the "WARP" problem. This also makes a check on your counters .. I have cross checks every 5 records and on every row there is an indicator of your location. I've done this because when zoomed in close for examination you will loose your way without these signposts. It is such a pain to zoom in and out constantly!! (4)-- Lastly I cannot stress this too much "SAVE OFTEN"!!!!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-17 07:00:27 +0100

Seen: 32 times

Last updated: Nov 25