Button to pull data from another sheet & another to erase

[Berry9]

Hi all, first time poster here.

I'm creating a budget for personal use. Basically I wish to forecast my fixed expenses on a calendar style sheet then using a button, pull the expenses on to a secondary sheet for that specific pay period. at the end of the period, use another button to erase the data. I'm not too familar with the coding so would like some help for anyone who likes a challenge,

'Budget' sheet outlines the fortnightly period showing income and fixed/unfixed expenses, while 'Bill Calendar' is a forecast for the next year set out like a calendar with each fixed bill under its corresponding date. The idea is to populate the 'Bill Calendar sheet and each pay period I hit a button on 'Budget!' to populate the cells with the corresponding fixed bill data if they fall within that period.

A drop down data list with each payday on the 'Budget!' sheet automatically sets the dates of that pay period in Budget!C9:P9 while fixed bills are labelled under (Budget!B11:B28). Simarlarly, on the 'Bill Calender' sheet, dates are set (B1:RG1) and fixed bills labelled under (A3:A20)

As an example:
Set drop-down payday to 15/9/23 and auto populate dates for period 15/9/23-28/9/23 in 'Budget!C9:P9. If I hit populate button, data match dates 'Budget!C9:P9 (15/09/23-28/09/23) to 'Bill Calendar!B1:RG1 and if match, pull data from lower cells, in this case it would be 'Bill Calendar!B3:O20.

The Erase button would then erase 'Budget'!C11:P28 at the end of the pay period.

Thanks in advance, see template

Budget template.xlsx

[AliGW]

You have marked this as solved - is it?