data model

Hello, I am trying to setup a data architecture for VBA based business simulator. There will be more devs in few weeks but for now I am the lead, tasked with initial project setup. General question is: what would you advice for a definition of custom class, holding a public array of variable...

Hello all. I have a staff list with unique IDs. Each staff member can be a team member, a team leader or a supervisor. To make it slightly more complicated, an individual can be a member of one team and a leader for another – but let’s park that for now. </SPAN> I need to produce a team sheet...

Hello everyone. I’m creating a simple management tool for a number of teams in the form of a standalone Excel 2013 workbook for each team leader, working on a standalone PC. The tool comprises three tables, each on a separate worksheet. These tables are added to the data model and used as...

Hi all, i am creating data connections between excel files in order to import tables of data from one file to the next. I have been successful so far at importing and refreshing such imported tables. however, one of my source tables is quite large and i do not need all of the fields each time...

I have a very large table in MSAccess that I imported into my Excel data model. Now I want to write the code to look up some values in the table to put it on a userform. I have written code to get values from tables in Excel, for example: Worksheets("ProjectPlans").Activate With...

I have been using excel pivot tables for some time and have used the group selection to roll dates into months, quarters, etc. Also, I have used the calculated fields capability to add new/useful columns. Recently, I started using the new data model capability in excel 2013 to work with...