I have an array (see below) which copies A3:A50 from each sheet and pastes it into H2:H49 of another workbook. The question is how do I modify my array so that it pastes each selection from my array but instead of always using H2:H49, it jumps down by 47 rows before it moves onto the next sheet in my array?
![]()
Please Login or Register to view this content.
Bookmarks