Hello,
My work just made us switch from Google to Microsoft. One of our main documents we use is a Google Sheet that is huge and interactive. The Master sheet has columns A-AZ or more and most of those columns used checkboxes. On the subsequent 20+ sheets is data relating to the Master sheet in terms of if on Master sheet column Z is checked, then show the data from columns A, G, AF, and Y. Each sheet pulls different data. Google Sheets use query for this. Here is the exact formula we use:
=query(Master!A:BL,"select A,B,AB,D,E,J,G,H where AN=True")
I realize that Excel does not do checkboxes well at all, and I am willing to change the thousand or so cells to drop down boxes or heck even just typing in a big bold X. Is there any way that Excel can do this type of advance formula? This workbook is the main function of our organization and has worked efficiently and exactly how we need it.
Thank you for the assistance.
