Please see attached Spreadsheet sample. There are three worksheets which are "Master List", "Enter Date Range", and "Data for Mail Merge"
What I'm trying to accomplish is to extract data from the Master List worksheet using a date range (based on column D of the Master List) and then have that data populate the worksheet named "Data for Mail Merge". I have a separate worksheet where I want to put a start date and end date. Basically after I enter a start and end date, I want data from the Master List to populate into the worksheet named Data for Mail Merge.
The reason for this spreadsheet is to use it with a mail merge using MS Word based on the information in the "Data for Mail Merge" worksheet.
Any suggestions on how to make something like this work? I want to keep this as simple as possible and understand this idea might not even be the best way to accomplish this. I am open to suggestions.