Hi I am a new user of VBA and I need some assistance. I would like to copy 100 (1-100) rows from an excel spreadsheet to a new workbook. Then copy the next 100 rows (101-200), etc. If I have 300 rows I would like to open 3 new 100 row workbooks.
I am assuming that this is not that difficult to do.