What I hope to do is to create a macro button that copies a row in a dynamic table, create a new sheet, then paste it over there. Then it moves down one row of the table, copy, create new sheet, then paste on the new sheet. Repeats until a certain value is meet.
I tried many ways to copy but it all failed... Please help!
Please Login or Register to view this content.