Link new tabs to main sheet

English
#1

Hi, hoping someone can help with this.

I use a spreadsheet to keep track of customer’s monthly payments, a simplified version is below.

There are many tabs, one for each customer. For new customers we use a blank sheet and save it as a new tab under their name. This needs to link into the master sheet so certain items of data entered on their tab also appear on the master sheet.

The problem I’m having is I have to manually amend the cell pointers every time a new customer sheet is created. Is there a way to automate this so the blank sheet will point to the new cells on the master sheet, or am I asking too much?

Untitled 1.ods (11.4 KB)

#2

…or am I asking too much?

Or you are using the wrong component of LibreOffice.
IMHO a typical application for Base/DB.

#3

Even if you continue with book keeping on sheets (which s a huge mistake) then you must not split equally structured information on separate sheets.
The spreadsheet software has several features to analyse data by client, day, month, quarter, year, if (and only if) data are stored in a flat, simple table. Apart from that, your uploaded document does not demonstrate your problem because there is only one tab.

#4

Thank you. I did wonder whether this would be the case, however I’ve never got to grips with databases. I have tried importing to DB and I’m stuggling to make it work.

#5

Thank you. This isn’t a book-keeping function (we have an accountant who does that) - it’s more for our own internal processes to quickly check where customers are up to.

Apologies for the file I uploaded. I’ll edit the 1st post with an amended version

#6

Your accountant uses some professional software which certainly allows reporting.

#7

I’m sure they do, but to access that would take too long. For instance, a customer walks in and asks “Can I have my next batch of products please?”. We can quickly open the file on our pc and check within a few seconds whether they’re up to date on payments. Asking the accountant would take hours or days.

#8

You better use two tables (with some effort, you could even use one - but it’s not reasonable). One would be clients (listing names and their start dates), the other would be payment dates (with first column having a drop-down (validity) referencing the names from the first page, and second column with payments).

Then using a pivot table, you could filter to any given name, and have their filtered data in a second.
A quick-and-dirty sample: Details.ods (12.1 KB)

2 Likes

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.