Please help. I have a macro that pulls in a text file.
This file has over 65,000 rows. The data pulled fills down sheet 1 and then once 65,000 rows is reeached a new sheet is inserted.
Once this new sheet is inserted how do i get the macro to activate this new sheet, and continue to fill in the data starting from cell A1 again.
please help
Bookmarks