Good Day Excelites,
I have a workbook with multiple sheets all identical. In different cells there are, name, age, address, occupation, date reporting etal. I want to extract from each sheet the name, age, occupation and address based on date reported with the criteria within the 7 days...