Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
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).
LegalSculptor More about the Mac insider program in the link below:
- https://insider.office.com/en-us/join/mac (for office 365). Unfortunately, their directions are incorrect as there is no such menu option "Check for update" under Help in any of the applications. Thanks for the assist in any event.
