VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

**johnmacpro** · 05-07-2016, 03:45 PM

Dear experts

I have master report which consolidated structured data i want split as three unique records depends upon state code in column P:P,copy to new workbook save file name as xlsb in target path.

there is 11 unique records in P:P like AZ,CA,FL,NY,NJ,NM,MS,NH,TX,GA,HI i want split wb as Report - AZ_CA_FL_MIS.xlsb,Report - NY_NJ_NM_MIS.xlsb,Report - MS_NH_TX_MIS.xlsb, atlast Report - GA_HI_MIS.xlsb becz there is 2 end file only so it get split only two values.

Please find the attachment Foxstreet is master file, rest of two file excepted result

**mike7952** · 05-08-2016, 11:47 AM

One way

Please Login or Register  to view this content.

**johnmacpro** · 05-08-2016, 01:52 PM

Thanks sir for Code I used to have state code more than 50 unique list any alternative code to avoid state code assign in filter record set manually! is there way to make it simple so as to avoid manual work?

**antoka05** · 05-09-2016, 08:32 AM

You could try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

**johnmacpro** · 05-09-2016, 02:13 PM

Yes sir it works till first 3 state code copy to newworkbook please check code with workbook!!

**antoka05** · 05-10-2016, 03:35 AM

Please try to change this line of the code:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

Regards,
Antonio

**johnmacpro** · 05-11-2016, 03:12 AM

Thanks sir Amazing Great Help!! made my day easy one

VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

LinkBack

Thread Tools

Rate This Thread

Display

VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Re: VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Thread Information

Users Browsing this Thread

Similar Threads

Split records into respective worksheet but different workbook

[SOLVED] vba split data as per column unique values and move to exact workbook into sht(opencall)

[SOLVED] VBA to data Split from column values as new workbook save into folder with dashboard sheet

VBA to split column values as new workbook along with hidding sheets

Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values

Split Rows For Unique Values In A Column To Different Workbooks

split records into multiple workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions