I am new to vba and would like to create a vba script to automatically copy data from an excel spreadsheet with a data condition and paste it into a dynamic template.

The Excel datasheet looks like this:

Item Type Date Initiated Description Responsible
Decision 5/1/2012 Implement Tracking Committee
Action Item 5/1/2012 Purchase System Lisa
Action Item 5/17/2012 Review Spreadsheet Mary
Decision 5/1/2012 Go Live with System Committee
Minutes 5/17/2012 Next Meeting OOO N/A
Minutes 5/1/2012 Reviewed Plan N/A
Decision 5/1/2012 Close Office at 4PM Committee
Action Item 5/1/2012 Finalize Document James


I am trying to create a VB script that will:
1.) Prompt the user for a date (ex: 5/1/2012)
2.) Pull all data rows with that date (5/1/2012) and place in another worksheet or document or email with the following format:

These are the minutes and actions from last week’s review.

Minutes:
· Reviewed Plan [Responsible is N/A, so nothing is shown]

Decisions:
· Implement Tracking – Committee [Description – Responsible]
· Go Live with System – Committee [Description – Responsible]
· Close Office at 4PM – Committee [Description – Responsible]

Action Items:
· Purchase System – Lisa [Description – Responsible]
· Review Spreadsheet - Mary [Description – Responsible]
· Finalize Document - James [Description – Responsible]

Any help on how to do any portion of this vb script would be great. I have code that will copy a row of data based on date criteria, but don’t know how to do the dynamic display of items in the template.

Thank you!