|
Featured Tutorial
Featured Macro
Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days
Part 2 shows the MACRO and Advanced Filter and the Forms button.
See the INDIRECT, ROW, TEXT and OR functions in a TRUE FALSE formula that will help to extract records of people who have a birthday in the next 14 days. See Advanced Filter and How to Create a MACRO and then add it to a Form button on the worksheet.
Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions: Excel MT142 p2: Array Formula for Counting Dates.
Start Advanced Filter From One Sheet and Go To Another sheet.
See the INDIRECT, ROW, TEXT and OR functions in a TRUE FALSE formula that will help to extract records of people who have a birthday in the next 14 days. See Advanced Filter and How to Create a MACRO and then add it to a Form button on the worksheet.
Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions: Excel MT142 p2: Array Formula for Counting Dates.
Start Advanced Filter From One Sheet and Go To Another sheet.