Forum Discussion

Pengguna bantuan's avatar
Pengguna bantuan
Copper Contributor
Oct 12, 2017

ask possibility - read data turn to calendar view

Hi there, Need help. I have sheet (sheet1)that contain: Column A as name Column B as class column C as date, withdate format (mm/dd/yyyy). Can I: Have another sheet, contain 2 month calenda...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 12, 2017

Hi Pengguna,

 

As a variant you may use Data->Advance Filter. Here is the sample within one sheet, but you may do the same for the separate sheets.

Your source columns shall have names in first row of the range. In location to which you'd like to copy in first row add names of the columns you will copy (nothing more). Somewhere add criteria, in our case on Date (add name for each criteria).  In L3

=$C2>EOMONTH(TODAY(),-1)

in M3

=$C2<=EOMONTH(TODAY(),1)

keep the row above criteri names emty. After that click Advance Filter and add the ranges (as on screenshot).

 

To update that's only click Advance filter once more, check copy to another location and OK - it remembers your settings.

 

More is, for example, here https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/

Sample is attached