Forum Discussion
ask possibility - read data turn to calendar view
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 calendar view (current month and next month), and:
- Read column C from sheet1
- whenever value column C from sheet1 in range between current month and next month, copy value column A and C from sheet1 into cell that represent day of column C in sheet 1.
Not sure my words can be understood or not.hope I deliver my needs clear enough.
Thank you
1 Reply
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
