Automatically filter and create pages

hi,

So you have one sheet and you want to filter in that page for all the items in column A and paste them in a newly created sheet? Also how big is the data. And why are you inserting a row?

Thanks

Wow. That was fast and awesome. That works beautifully and exactly like I was hoping.

Can I paste this data into an already existing sheet? I see where I can change which cell it pastes into.

Or better yet. I have a "template" that this data will paste into. Can I have it create or copy that template to a new page and then paste the filtered data into each newly created template page?

Sorry if that was to much to ask. But man that was fast and awesome. I want to learn VBA like that.

Actually, this morning I did find one problem. Everything works like it is supposed to but for some reason on every new page it keeps the first line from the main data source that the code is pulling information from.

I am trying to see if I can find the issue but I am having some trouble.

Any help would be greatly appreciated.

Thank you

Never mind, I see why it keeps the first row now. Is there a way I could keep it from not saving the first row? Just in case I didn't need it.

Okay so I figured out that this is the section of code that I need to change:

Please Login or Register  to view this content.

The problem I am having is that it is also copying the top row or the row that I do not need to copy. It is my header row. I only need to copy the rows after the first row. I have been trying but I am having some trouble. Anyone have any pointers or ideas?

Originally Posted by whatsmyname

Okay so I figured out that this is the section of code that I need to change:

Please Login or Register  to view this content.

The problem I am having is that it is also copying the top row or the row that I do not need to copy. It is my header row. I only need to copy the rows after the first row. I have been trying but I am having some trouble. Anyone have any pointers or ideas?

Actually now that I look at it, I think this might be the section I need to work with to accomplish not copying the first row:

Please Login or Register  to view this content.

That did it sir. Thank you very much. Man once you really start to think about things vba is really simple. It's just a matter of understanding the objects and how to work with them and how you can manipulate them.

Here is the completed code working the way I am wanting it too:

Please Login or Register  to view this content.

Thank you very much sir!