Forum Discussion
Making contact list form multiple sheets
Hi, I am trying to make a contact list from multiple sheets that we use for different trades. All the contact information is in the same cells on each sheet. I am wanting to add a sheet at the end t...
I don't know if you're an insider, but this request is something TOCOL and WRAPROWS were made to handle.
This is all you'd need (This sample has the data going down 30 rows):
=WRAPROWS(TOCOL(Sheet6!A1:D30,1,1),5)