mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have about 20 tabs with lists of data, the headings are all on row 1 and the data is laid out identically on each tab. The number of rows of data on each tab will differ by tab.
How can I move all of the lines from every tab and lay them out on a single tab? I dont really want to use a macro or VBA. Each tab will have no more than 200 lines so I dont mind a formula based solution that moves 200 lines from each sheet.
Thanks
How can I move all of the lines from every tab and lay them out on a single tab? I dont really want to use a macro or VBA. Each tab will have no more than 200 lines so I dont mind a formula based solution that moves 200 lines from each sheet.
Thanks