vba to split unique values in column P:P along with existing sheet of partner

**johnmacpro** · 08-03-2016, 01:18 PM

Dear expert

I have rawdata workbook i want split unique values as new workbook from column P:P to desire location save with new name along with existing sheet of Partner!

find the attachment of zipfile

I want split as workbooks of TE001 FY 16.xlsb FY-16 sheet name along with Partner, and another workbook TE003 FY 16.xlsb sheet name along with Partner from column P:P.

assume that TE001 rows more than 65000,TE003 rows more than 85000.

Regards

vba to split unique values in column P:P along with existing sheet.

**johnmacpro** · 08-04-2016, 02:49 PM

Any experts help on this?

**jaslake** · 08-04-2016, 05:14 PM

Hi John

Been a bit busy the last several weeks as a result of a major hail storm. I'll look at this ASAP...seems like a rather direct Filter exercise...except that Xcel sometimes has Filtering issues with that many records.

If no one has responded I'll look at it...currently dealing with the Siding Contractor...next week the Roofing Contractor...won't be immediately.

**johnmacpro** · 08-05-2016, 01:57 AM

Ok sir No probs waiting for your valuable respond from experts!!

**jaslake** · 08-06-2016, 03:09 PM

Hi John

Do you have a "Desired" location to which to save the newly created Workbooks or do you wish the User to select the "Save To" location?

Regarding this...does it mean as it says ("EXISTING SHEET") with no modification?

along with existing sheet of Partner!

Are there only two PUDO Codes?

**johnmacpro** · 08-07-2016, 01:10 PM

ya there is only two pudo i just used to reduce the file size.

this is my desire location : C:\Users\Admin\Desktop\Mohan and yes i meant the exisiting sheet is called Partner sheet only with no modification

**jaslake** · 08-07-2016, 04:08 PM

Hi John

This Code is in the attached and appears to do as you require. If the PUDO Workbooks do not exist the Code creates them. If they do exist Data is cleared and then updated with fresh Data.

CTRL + x will fire the Code...let me know of issues.

Please Login or Register  to view this content.

**johnmacpro** · 08-08-2016, 02:08 AM

Ya It works sir but its prompt the P:P column values by array i dont want assign the value in the code array , becoz i have N number list of values like TE001,TE002....TE100 Etc so it take me hard time to assign the pudo in code filter array.i want take unique values of P:P depends upon no of values split workbook and one more I want move partner sheet along with data of A:B Range. thanks alot

Find the attachment

**jaslake** · 08-08-2016, 02:22 PM

Hi John

So, there will be more than two PUDO Codes...that's fine...can be handled.

Regarding the Partner worksheet...should it include ONLY the Partners for each individual PUDO Code? Or, should it include ALL the Partners in Master sheet DATA?

**johnmacpro** · 08-08-2016, 03:14 PM

Ya partner sheet should include all partners as of now A1:B20 ,Copy to all splited workbooks

**jaslake** · 08-08-2016, 03:44 PM

Hi John

The Code has been modified to create a list of all available PUDO Codes and cycles through that list to create the individual workbooks. If the Partner worksheets are incorrect you'll need to define better for me what you require.

Please Login or Register  to view this content.

**johnmacpro** · 08-09-2016, 12:26 AM

Kudos master amazing stuff Solved!!

**jaslake** · 08-09-2016, 05:44 PM

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

vba to split unique values in column P:P along with existing sheet of partner

LinkBack

Thread Tools

Rate This Thread

Display

vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Re: vba to split unique values in column P:P along with existing sheet of partner

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to split report according to segmentation of rows unique values to sheet check

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

VBA to split unique values from 2 sheet end with formula

split column values as new wb along with 2 existing sheet (dashboard&pivot)

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

[SOLVED] Extract Unique Values From Column In One Sheet and Populate Unique Values In Another Sheet

Split Rows For Unique Values In A Column To Different Workbooks

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions