Forum Discussion

LegalSculptor's avatar
LegalSculptor
Copper Contributor
Aug 12, 2022

How to combine the rows in multiple worksheets into one master sheet?

Apologies if the solution is trivially obvious but for the life of me I can't find the solution. Here is the problem:   I have two worksheets functioning as a document log of sorts. Each worksheet ...
excel
Excel on Mac
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 12, 2022

LegalSculptor First of all, Excel for Mac doesn't yet support all PQ functionality you may have read about. That said, why would you maintain two separate sheets, wanting to create a third as a master? Put all in one sheet, add a column for the category and work with that. 

PoKaroo's avatar
PoKaroo
Copper Contributor
Aug 30, 2022
This is not helpful. I'm in a similar situation as OP. We have a project document with separate tabs for each project manager, but we want to see a consolidated list of all active projects. I'm trying to pull the data from each tab into a single worksheet but I can't find a simple solution. The column headings are all the same.
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.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Aug 31, 2022

        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.

Resources