Break multiple lists from different sheets in to new files with multiple sheets

**belesky** · 12-01-2015, 12:23 PM

Hi,

this is my second attempt to start this thread

First of all my file is to big to upload, secondly I am using modified code from this clip: https://www.youtube.com/watch?v=-vP0kbuyVvY. Here is my current, working code:

Please Login or Register  to view this content.

I would like to implement some changes to it.

I would like new macro to create same files as it does right now, but with multiple spreadsheets. Each spreadsheet would be named after a spreadsheet from the original file f.e name of months. Each spreadsheet would consist of a fragment of a list that was filtered(same filter for every spreadsheet) from the original sheet. Created files would have auto fitted column size in each spreadsheet.

Is there anyone who can help me solve this pickle?

**skywriter** · 12-01-2015, 12:43 PM

First of all my file is to big to upload,

It doesn't need to be the whole file, just a small sample that clearly shows the structure of your data and what you want.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic