VBA for generating new WS based on criteria and copying info into it

Here's my stock macro for this task. It gets unique values from column A, grabs all the rows with matching values and puts them onto a new sheet named for the unique value. It sorts the sheets alphabetically. It creates the sheets as needed.

Please Login or Register  to view this content.

For a filter command to work, we do need at least one "title" cell at the top. You're saying that you actually have two?

The code section "get a temporary list of unique values" is copy all of column A to column EE. If the resulting list in EE includes a value in E2 you want excluded (we have to leave E1 in as a "header"), then let's just delete that cell before proceeding. Edit this section:

Please Login or Register  to view this content.

If this doesn't help, post up a usable example workbook so we can look at the problem directly together.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

I have a similar problem, any chance you can help me with this?

I can create the tabs and copy report columns to each tab with the code below. What I'm trying to do is instead of copying the columns, I'd like to copy a worksheet named "Sample" and populate each report with the same format I have in that "Sample" worksheet. Any help is appreciated...

Please Login or Register  to view this content.

'FILL OUT A TEMPLATE FROM A DATABASE
I have a macro for taking the data from a database and filling out a template sheet over and over again with the data.

Data Into Template

The macro fills out the template and saves each one as a separate file, but that last part can be tweaked to do other things, this is mainly to demonstrate a simple way to fill out a form from a row-based database.

The technique is complete, you should be able to adapt it to your scenario.

Glad to help.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.