how to transfer data in that particular worksheet in excel

 

Hi Sir,

I have query that in my data base how to generate new worksheet automatically as per remarks and transfer data in that particular sheet which has showed below please help me on this in excel using vba.

Thanks

amar  

 

 

Customer Name

loan Amount

applied date

remarks

DANANJAY

1260000

20/06/2014

closed

THEJESH

385000

21/06/2014

sutch off

MOHINUDDIN

600000

30/06/2014

not interested

SEETHA

640000

07/09/2014

follow up

SURI

400000

08/08/2014

follow up

PRASHANTH

375000

21/06/2014

closed

DEBASHIS

600000

30/06/2014

closed

VASUDEVAN

1000000

07/09/2014

follow up

SANJEEV

430000

08/08/2014

closed

RAO

800000

21/06/2014

closed

KVASANTRAO

500000

30/06/2014

closed

PILLIM

1000000

07/09/2014

closed

PRASHANTH

500000

08/08/2014

not intersted

 MURTHY

700000

21/06/2014

not intersted

 PAUL

360000

30/06/2014

not intersted

ARAVIND

700000

07/09/2014

closed

RAJIV

200000

08/08/2014

closed

 

 

 

By: AMAR

Leave a Reply

Your email address will not be published. Required fields are marked *