Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
Using a single worksheet isn't practical since each project manager edits/manages their projects individually. But we do need an overarching status of each project.
PoKaroo Are you also using a Mac?
Riny_van_Eekelen Yes on mac. Version 16.64
PoKaroo I'm sorry for not being very helpful here. If you are not an Insider in the Beta channel, you'll have to wait until PQ comes to the Mac for the general public (don't know when that will be), get your hands on a PC and use PQ on that one. Otherwise you are going to be stuck with manual copying and pasting or developing a macro that can do it all for you. Unfortunately, VBA and macro's are not subjects I fancy getting involved in.
Riny_van_Eekelen and VBA and Macros often times are prohibited by corporate IT security policy (for better or for worse).
Is it possible to sign up for Beta access? Or does one have to be a developer in order to do so?
While I understand that using pivot tables would 'essentially' produce this result, I am somewhat surprised that Excel, in its entire history?, doesn't have a function that simply consolidate rows in the various worksheets (with these worksheets serving as the single source of truth) into one. It seems a rather basic feature.
Nevertheless, I have accepted that, for the time being, this simply is not possible to do on the Mac without the use of Macros/VBA (or PQ on PC).
