Hello everyone;
I have a workbook that contains apprx. 30 worksheets(this number will vary), each of which contains 1200 rows of information. How can I loop through the workbook to copy, for example rows 5,6,350, 650, and 1100 of each sheet, to a new worksheet? (so that I end up with 30 new sheets that contain only the selected rows) I know how to loop through the workbook and copy all of the sheets(that contain all 1200 rows), but don't know how to copy (or paste?)just the rows that I need.
Any help would be greatly appreciated. Katey