Excel Macro Help

[eddiet]

Hey,

I think I got my last issue resolved now, so I need some more additional help because this code will be beyond my self-taught skills.

This is what I'm trying to do.


I have a table of information that for example has Y number of columns of information. Lets then say that I have X amount of rows of information. What I'm trying to do is create a macro that will count the number of rows, because it'll be a variable amount of data in real life, and then create X amount of tabs and then populate this standard template (the standard template would be tab#1) that I have with the respective information from that table. So basically its like when you use Excel and Word to create individual letters.

So to sum it up, I want to have this macro to count the number of rows of information, then make that number of tabs of a standard template (the standard template would be tab#1), and then populate this template with the respective information.

Can anyone help me get started, I like a challenge so its not completly necessary to give me all the code, just a good way to start (like how to get the macro to "count" the rows of data and then make copies of the template).

Thanks

 

[eddiet]

sorry I should have been more clear. Its making the copies of the sheets like it should, but its making more copies of it then it should. If I remember right its about 12 copies that it makes

 

[mikerickson]

Yes merged cells will have an effect. And down the line as well. If you can work without merged cells, things will be much easier.
Does each block of data have the same number of rows?

 

[eddiet]

Yes they do, so I think my little modification to "x" will always work.

Thanks again for all your help