Code for post # 2
Brief Description of code:
. – A 1 dimension “Mega” Array is made of size equal to the number of data sheets ( excluding the main sheet )
. – The Array elements of this Array are themselves Arrays. Each of these Arrays contain the data for a sheet
. – An output Array is made equal in “row” size to the total number of data rows in all data sheets
. – The output Array is then filled with its “rows” in the appropriate order.
. – Finally the output Array is pasted out to the master list in one go.
Bookmarks