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
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