johnnytominaga
New Member
- Joined
- Apr 27, 2018
- Messages
- 19
Hey guys!
I need to copy 1 out of every "n" number of rows up to the end of the table from one worksheet to another.
I've managed to do it with a For Each loop. Using that method takes a while to process all data depending on the number of cells though.
I believe that can be optimized by using an array. Am I right? If so, how can that be accomplished?
I'm working on Excel 2016 on Windows 10.
Thanks a lot,
Johnny
I need to copy 1 out of every "n" number of rows up to the end of the table from one worksheet to another.
I've managed to do it with a For Each loop. Using that method takes a while to process all data depending on the number of cells though.
I believe that can be optimized by using an array. Am I right? If so, how can that be accomplished?
I'm working on Excel 2016 on Windows 10.
Thanks a lot,
Johnny