Copy data from one sheet to another sheets in the same excel based on date

[shansakhi]

Hi All,

Good Morning.

I require your assistance to build a macro to copy data from one sheet to another sheets in same excel file based on date criteria.


Below is the main file where we have three sets (may be more in actuals) data which we need to segregate to three different sheets based on date criteria.

Below Data is in one sheet. (Please note the column and rows may increase)

ABCD123
ORG	Dest	Car	PT	FC	Amount	Eff Date
A1	B1	AB	HUB	PS	412	23-Sep-14
A2	B2	AB	HUB	KS	442	24-Sep-14
A3	B3	AB	HUB	LS	482	25-Sep-14
ABCD456
ORG	Dest	Car	PT	FC	Amount	Eff Date
A4	B4	BB	BUB	PB	400	24-Sep-14
A5	B5	BB	BUB	KB	520	25-Sep-14
A6	B6	BB	BUB	LB	300	22-Sep-14
ABCD789
ORG	Dest	Car	PT	FC	Amount	Eff Date
A7	B7	CB	CUB	PC	302	21-Sep-14
A8	B8	CB	CUB	KC	102	22-Sep-14
A9	B9	CB	CUB	LC	600	20-Sep-14

<TBODY>
</TBODY>

We would like to have three dirfferent sheets ABCD123, ABCD456 and ABCD789 (the names may change).
Then based on Eff Date -- if data is availabe from same day onward then we need to copy the same and paste it to respecting sheets.

Considering 23 Sep 2014 is today ...

The data in output sheets would be as below ...

Sheet1 - ABCD123

ORG	Dest	Car	PT	FC	Amount	Eff Date
A1	B1	AB	HUB	PS	412	23-Sep-14
A2	B2	AB	HUB	KS	442	24-Sep-14
A3	B3	AB	HUB	LS	482	25-Sep-14

<TBODY>
</TBODY>

Sheet2-ABCD456

ORG	Dest	Car	PT	FC	Amount	Eff Date
A4	B4	BB	BUB	PB	400	24-Sep-14
A5	B5	BB	BUB	KB	520	25-Sep-14

<TBODY>
</TBODY>

Sheet3-ABCD789

"NO NEW DATA"
(As there is no data available from 23 Sep 14 onward)

Regards,
Shantanu