lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I have a workbook that I am attempting to aggregate all tabs onto a master tab, 50-60 I think.
I'm using =QUERY({'data 1'!A2:Q;'data 2'!A2:Q;'data 3'!A2:Q.......},"select * where Col1 is not null",0)
But If I try to paste the entire formula so I don't have to click on every tab to set the link, it doesn't color/find the tab and I get Formula Parse error. I can delete 'data 1'!A2:Q, go highlight it on that actual tab to set the link, and then it works, but if I cut/paste text it's the exact same formula.
I'm using =QUERY({'data 1'!A2:Q;'data 2'!A2:Q;'data 3'!A2:Q.......},"select * where Col1 is not null",0)
But If I try to paste the entire formula so I don't have to click on every tab to set the link, it doesn't color/find the tab and I get Formula Parse error. I can delete 'data 1'!A2:Q, go highlight it on that actual tab to set the link, and then it works, but if I cut/paste text it's the exact same formula.
