[Solved] Multi-paste row into calendar on due dates

[NTintheNT]

Hi all,
Don't know if possible?
I have a self made Budget calc/monitor, Bills data is collected, calculated and formatted into Year Sheet columns format, stored on Stubbs Sheet.
At present, I am copying a Row from Stubbs, and pasting into Year Calendar for every due date that bill is due.

Is there a way to populate the calendar Via macro or formula?
Thanks guys

[karolus]

Is there a way to populate the calendar Via macro or formula?

Yes of course!

[NTintheNT]

Why thank you Karolus, any hint as to where I could research this?
NT

[MrProgrammer]

I have a self made Budget calc/monitor …

There must be hundreds of topics about this sort of idea. You might benefit by reading them. You can search for them as well as I. The search box is at the upper-right of every forum page. Some probably will refer to "budget' or to "bank statement" or "personal finance". There are also applications like GnuCash which have all of this programmed for you using a database. Of course you will need to read their documentation. But, depending on your skills, this might be quicker than learning how to do this yourself with Calc or with Base. They will also have features which may be helpful for you but which will be difficult to do in Calc without a great deal of work. If you don't like GnuCash, which is downloaded about 7000 times a week, there are plenty of others, and some are free to use. I don't personally use any of them.

I am copying a Row from Stubbs, and pasting into Year Calendar for every due date that bill is due.

If you use Data → Filter to show only the rows with the desired due date, paste operations on those columns will affect only those rows. Cells in the column which have been hidden by the filter are not modified. You may need to adjust your Calendar sheet to allow it to be filtered as needed. If multiple bills can be due on the same date, the situation is a lot more complicated. Read about filters in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum.

If you need any additional assistance attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet. Explain what data you want to copy. Explain what the desired due date is. But unless the primary goal is to learn about Calc, your time creating a budget would be better spent in learning how to use one of the many budget applications which have been created.

[Tutorial] Ten concepts that every Calc user should know
[Tutorial] Calc date formulas

[NTintheNT]

Thank you Mr. Programmer
I have a bit of reading then.
Muchly appreciated
NT