Create New Workbook from Existing Workbook w/ Date Range

[martenian]

Hi All,

I'm looking for some help writing a macro to create a new workbook from an existing workbook w/ some unique requirements.

1. Copy data from Workbook1
2. Create new workbook with predefined column headings and copy data from workbook1 (where column H = "Y") to the respective column in the new workbook.

Here's where it gets tricky. As you will see in the screenshots below there are two date columns in workbook1 (Start Date & End Date). I need the start date to be copied to cell A2 in the new workbook, and then pulled down all the way through the end date listed on workbook1. I have no idea how to accomplish this.

1. I then need the data in the remaining columns to be copied down to the last row (i.e. the row with the end date)

WorkBook1:

Security ID	Price	Policy	Run	Source	StartDate	EndDate	PublishToWso
LX156472	130	Global	SF Pricing Run	Markit (Loans) - Mid	09/16/10	12/01/16	Y

<tbody>
</tbody>

New WorkBook:

Date	Primary ID	Source	Bid	Ask	Mark		Prior Date Price	Delta
01/01/16	LX156472	Markit (Loans) - Mid	130	130	130
01/02/16	LX156472	Markit (Loans) - Mid	130	130	130
01/03/16	LX156472	Markit (Loans) - Mid	130	130	130
01/04/16	LX156472	Markit (Loans) - Mid	130	130	130
01/05/16	LX156472	Markit (Loans) - Mid	130	130	130
01/06/16	LX156472	Markit (Loans) - Mid	130	130	130
01/07/16	LX156472	Markit (Loans) - Mid	130	130	130
01/08/16	LX156472	Markit (Loans) - Mid	130	130	130
01/09/16	LX156472	Markit (Loans) - Mid	130	130	130

<tbody>
</tbody>

Any help would be greatly appreciated!!!!

 

[pbornemeier]

What worksheet in workbook1 holds the data?
If there are multiple lines in that worksheet, does each line get a new workbook? a new worksheet in the same workbook?
The start and end dates in your example don't match your text. Please provide a reworked example.