Help with auto-populating a new sheet row, based on the date from the master sheet.


Screenshot 2022-04-06 131232.pngHello,


I need help with a project I'm working on. I'm making a calendar for appointments. There is a master sheet, and one for every month. I need help auto-populating each month, based on the date inputted on the master tab. 

For example, copy the entire row to the tab name January, if the date on the master tab ranges from anywhere from January 1st to the 31st. 


Attached is a screenshot of the master list tab. The other tabs will have the same headings. 



1 Reply



The FILTER function should do it for you (if you have the most current version of Excel). 


Here's a video that explains it.


Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...