Create new workbook partywise and save in folder date wise.

[visha_1984]

hi team

I have a master workbook and i need macro to create workseets party wise and it should save in date wise folder.

i have attached sample workbook for your ref.

kindly help

[piyushanand]

there can't be more than one folder with same name
and date column in sample file contains same date

Do you want all the party name in the same date folder???


Piyush

[visha_1984]

Thanx Piyush for replying,

yes i need all the party name in the same date folder but workbooks should be party wise.

[visha_1984]

any one pls help

[piyushanand]

Here is the solution but it still needs improvement

Please Login or Register  to view this content.

Piyush

Do not forget to click the star(*) below left

[visha_1984]

Piyusha ur Great
it works fine


Many Thanks
thanku very much once again.
Good day.

[visha_1984]

oh sorrry

worksheets are blank ????

[piyushanand]

I am sorry if I got it wrong
what do you want in the worksheets????

[visha_1984]

anybody can help me macro is creating workbook but it should copy data also.

[visha_1984]

Hi,Piyusha

ur code is working fine but unable to move data from master workbook to created workbooks with header.

Good Day

[piyushanand]

Hi...


Please check the attached file

[visha_1984]

Thanx a lot Piyusha for pending ur precious time for this.
code works fine.
Have a nice day

[visha_1984]

Hi,

where i insert Autofilt column width in below macro.

Please Login or Register  to view this content.