How to breakdown one row into several identical rows based on certain date range criteria?

[fleer]

I would like to breakdown one row data into several rows based on start and end date say feb 4- Jun 15 as Feb 4-28, Mar 1-31,Apr 1-30,May 1-31 and June 1-15 and populate the results onto another spreadsheet with the same columns. I am new to vba and need kind help from your guys.

EVENT_ID

EVENT_KIND

UNIT_NAME

UNIT_ID

OWNER_NAME

PLANT_ID

PLANT_NAME

IND_CODE

IND_DESC

PHYS_CITY

START_DATE

END_DATE

ASSIGNEDTO

ESTVALUE

ESTCLOSE

RELEASE_DT

368314

T

ABT Nr. 202 (ABT-2/2) (Crude 02)

2112273

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

18-Aug-17

11-Sep-17

19-Oct-17

368318

T

ABT Nr. 202 (ABT-2/2) (Crude 02)

2112273

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

15-Sep-18

9-Oct-18

17-Jan-18

368315

T

ABT Nr. 202 (ABT-2/2) (Crude 02)

2112273

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

12-Sep-15

6-Oct-15

21-Apr-17

368313

T

ABT Nr. 202 (ABT-2/2) (Crude 02)

2112273

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

6-Aug-16

30-Aug-16

21-Apr-17

368349

T

ABT Nr. 305 (ABT-2/1) (Crude 01)

2112270

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

12-Sep-15

6-Oct-15

17-Jan-18

368346

T

ABT Nr. 305 (ABT-2/1) (Crude 01)

2112270

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

18-Aug-17

11-Sep-17

19-Oct-17

368340

T

ABT Nr. 305 (ABT-2/1) (Crude 01)

2112270

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

15-Sep-18

9-Oct-18

21-Apr-17

368348

T

ABT Nr. 305 (ABT-2/1) (Crude 01)

2112270

Bakinsk NPZ JSC

1051655

Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)

6

Petroleum Refining (HPI)

Baku

6-Aug-16

30-Aug-16

21-Apr-17

<tbody>
</tbody>

 

[The_Macrotect]

Hi fleer,

I understand that you want to make a new sheet based on the information from the original sheet, but I don't understand what information you'd like to be on the new sheet. Can you show me what the new sheet is supposed to look like based on your example?

 

[fleer]

Hi fleer,

I understand that you want to make a new sheet based on the information from the original sheet, but I don't understand what information you'd like to be on the new sheet. Can you show me what the new sheet is supposed to look like based on your example?

Hi mate tks for the response. Actually I would like to have all the other columns intact ie the row is split into several only based on the multiple periods and other info are automatically copied down. Guess it is not easy to achieve? Looking forward to ur reply. Thanks a lot .

 

[The_Macrotect]

Hi mate tks for the response. Actually I would like to have all the other columns intact ie the row is split into several only based on the multiple periods and other info are automatically copied down. Guess it is not easy to achieve? Looking forward to ur reply. Thanks a lot .

I'm still unclear on what the final result would be. What would the new sheet look like in your example?

 

[fleer]

I'm still unclear on what the final result would be. What would the new sheet look like in your example?

Exactly the same with only start and end dates broken down into individual months.

 

[The_Macrotect]

Ok, I think I understand...

Should the first two rows look like this on the second sheet?

Excel 2007 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	EVENT_ID	EVENT_KIND	UNIT_NAME	UNIT_ID	OWNER_NAME	PLANT_ID	PLANT_NAME	IND_CODE	IND_DESC	PHYS_CITY	START_DATE	END_DATE	ASSIGNEDTO	ESTVALUE	ESTCLOSE	RELEASE_DT
2	368314	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	18-Aug-17	31-Aug-17				19-Oct-17
3	368314	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	1-Sep-17	11-Sep-17				19-Oct-17
4	368318	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	15-Sep-18	30-Sep-18				17-Jan-18
5	368318	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	1-Oct-18	9-Oct-18				17-Jan-18

<tbody>
</tbody>

Sheet2​

 

[fleer]

Ok, I think I understand...

Should the first two rows look like this on the second sheet?

Excel 2007 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	EVENT_ID	EVENT_KIND	UNIT_NAME	UNIT_ID	OWNER_NAME	PLANT_ID	PLANT_NAME	IND_CODE	IND_DESC	PHYS_CITY	START_DATE	END_DATE	ASSIGNEDTO	ESTVALUE	ESTCLOSE	RELEASE_DT
2	368314	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	18-Aug-17	31-Aug-17				19-Oct-17
3	368314	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	1-Sep-17	11-Sep-17				19-Oct-17
4	368318	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	15-Sep-18	30-Sep-18				17-Jan-18
5	368318	T	ABT Nr. 202 (ABT-2/2) (Crude 02)	2112273	Bakinsk NPZ JSC	1051655	Bakinsk Heydar Aliyev Lower Refinery (Azerneftyag)	6	Petroleum Refining (HPI)	Baku	1-Oct-18	9-Oct-18				17-Jan-18

<tbody>
</tbody>

Sheet2​

Yes mate you r right