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

Copper Contributor

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

@ManuelRodriguez 

 

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

 

Here's a video that explains it. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

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, but were limited to power users. With Dynamic Arrays we have rebuilt the calc engine, effectively turning all formulas into array formulas ...