Inserting no of row is variable provided in one cell.
Based on the cell value, Rows need to increase and decrease.
I don’t know which method i can use?
Please help me.
Welcome!
There are many possible solutions - from using the OFFSET() function and a filter (standard or advanced) to writing a macro. We can tell you in more detail when you ask in more detail: for which operating system and what version of LibreOffice are you looking for a solution, where to put the extra rows after decreasing the counter - delete them or just make them invisible, the necessary rows are needed for calculations or for entering information or for printing . Do you see? There are a lot of clarifying questions, let’s talk.
My data: there are 10 person each borrowed me multiple time from me. When i enter number of times they borrowed, i want libre office to add rows below their name.
In Short: when a same person borrowed from me 3 time, libre office need to add 3 row below their name to add amount they have borrowed.
Operating system: windows 11
Libre version: 7.6.4
You might want to enter in these new rows when and how much each borrowed?
This is very similar to the question we discussed here a year ago. Please look at the solution that was proposed - perhaps this is what you are looking for?