Macro to Filter by PVT, Copy and Create Individual Files

**GCLIFTON** · 11-08-2016, 12:00 PM

Need assistance with macro that will Filter the Data tab by Column B “Profile Code” or create a Table by Profile Code. Select each Profile Code ,copy all lines and headers and then Create a .xls file and Place the copied date into the new file into a Folder c: My Document/Test/ Save and loop to the next Profile Code and do the same things:
And is there a way I can add this to the back end of the Macro that is currently there so I don’t have to run 2 different Macros.

Sample Spreadsheet is attached

**jaslake** · 11-08-2016, 03:24 PM

Hi GCLIFTON

You indicate to create .xls Files. What's the earliest version of Excel in which the Code needs to run?

**jaslake** · 11-08-2016, 04:27 PM

Hi GCLIFTON

Try this Code in the attached. The Code to run the Workbook creation is called from your existing Code. Please change the Path to where the New Workbooks are to be saved.

Please Login or Register  to view this content.

**GCLIFTON** · 11-09-2016, 09:58 AM

Received this error when attempting to run.

**GCLIFTON** · 11-09-2016, 09:59 AM

Sorry forgot the attachment The first highlighted is the error line and i attempted to skip and the later two errors occurred when attempting to skip

**jaslake** · 11-09-2016, 01:48 PM

Hi GCLIFTON

No idea...runs as expected on my platform. Do you have the issue on the File I attached?

Do you have a Worksheet called "Data"? You did in your sample file.

Your Code is missing the trailing "\" in the variable "myPath"

Macro to Filter by PVT, Copy and Create Individual Files

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Filter by PVT, Copy and Create Individual Files

Re: Macro to Filter by PVT, Copy and Create Individual Files

Re: Macro to Filter by PVT, Copy and Create Individual Files

Re: Macro to Filter by PVT, Copy and Create Individual Files

Re: Macro to Filter by PVT, Copy and Create Individual Files

Re: Macro to Filter by PVT, Copy and Create Individual Files

Thread Information

Users Browsing this Thread

Similar Threads

Create individual files from a row

VBA help to create new files with data and save as individual files with specific names

How do I create a macro that will split my spreadsheet into individual files?

How do I create a macro that will split my spreadsheet into individual files?

create a macro that will run a filter, of all 5 files against the picture column

[SOLVED] Need macro to filter, create tab on filter and copy/paste

set up a macro to copy/ move sheets to individual files

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions