• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recreating Vijay's Database using Excel 2011 for Mac

D

DME

Member
Hello all,

I've researched the forum and don't believe I've found an answer for this (though please kindly point me to one if I've missed something!).

I recently began using a Mac and having a terrible time navigating Excel 2011. I'm hoping to create something with similar functionality to Vijay's previous post "Using Excel As Your Database".

http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/

The issue I'm running into is the ActiveX piece as it isn't supported in Excel 2011 for Mac.

While I can use something different to allow the user to select multiple filter criteria, I can't figure out how to modify the VBA included to reproduce that same "data mining" capability as shown on the "View" tab.

Any thoughts or suggestions? Is there an easier way to reproduce this?

Many thanks in advance for any insights you can offer!
 
Good day and welcome to the forum, this may help you but Chandoos site is primarily for excel PC.


In Excel 2011 for Mac, Microsoft has re-introduced VBA, and it's even finally the same version of VBA that Excel for Windows has been using all along. However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms. I've only done enough testing to know it's going to be a lot of work to make my stuff compatible.

Ron de Bruin has started documenting the differences between Mac and Windows Excel VBA in VBA code in Mac Excel 2011 and Windows Excel.


.
 
Thank you for the prompt response and welcome @bobhc !

Any non-VBA solutions you'd recommend? The real goal is to:

1.) Have a large table of master data in the first tab
2.) Ask several (3+) questions in the 2nd tab
3.) Once populated, show a subset of tab one's data based on the answers provided

This will be an ongoing document to be utilized weekly by several users. I wanted to avoid some type of pivot (I don't think I can use slicers in Excel 2011 for Mac anyway) or some type of advanced filter on the master data in the first tab.

I had considered a lookup formula based on the criteria selected to pull over a unique identifier to the new table...then use other formulas to pull over the details for that unique identifier. Feels like I'm over-complicating the whole thing though and I'm convinced there's an easier way...though I could be wrong. :)

Thanks again!
 
You must log in or register to reply here.
Back
Top