ultracyclist
Active Member
- Joined
- Oct 6, 2010
- Messages
- 271
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with 40 tabs that contain the same column headers and range of cell data (A1:L1500). I want to create a formula on the Summary tab in cell A1 that pulls in the data from all tabs within this range. I tried using the Get Data function and also tried grouping the tabs in a formula to pull everything over, but cannot get it to work. Does anyone know if its possible to create a formula or some other method, i.e. VBA that will accomplish what I'm trying to do.
Thanks,
Tom
Thanks,
Tom