multiple tables

  1. P

    How to export multiple table from Access to Excel with specific sheet name into a single workbook

    Hi Guys, Anyone who can help me how to transfer multiple tables from Access to Excel with specific file name and sheet name into a single workbook only? The code works fine for exporting a singe table but the code stops at "Set xlSheet1" 'SET UP EXCEL Dim FilePath As String Dim...
  2. L

    Excel 2007 Query Join Multiple Table & Show All Records From First Table

    Hi, I've generated a query with 4 tables which consists of 1 main table & 3 other tables that join to the main table. I've joined all 3 tables to the main table & it works fine except for if 1 of the records from the other 3 tables is blank, then it doesn't show the record from the main...
  3. H

    Add Calculated Field/Formula to Pivot Table referenced as a Data Model

    Afternoon, I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out. I have sales data based of months, and...
  4. N

    Index match based on two tables

    I am using an individual number (Master NSN) on my main sheet to return Team name based on two other tables. I match the tims-nsnnumber from the first table (Achieved10Credits) with the Master NSN. The main issue lies with adding in a second criteria based on another lookup. I aim to use the...
  5. S

    Create Query Linking Two Tables Together

    Hello, I have two tables. One labelled "Records" and one labelled "Comments". I both tables I have an "Account Number" However in the records table, there will only ever be one record for each account. In the comments table there can be any number of records for that account. The idea...
  6. N

    Cross reference multiple tables

    I want to relate multiple table together to a single field, and that way I can use data from multiple tables in a single visualization. Can someone please tell me if this is possible and if so, how? Thanks. The tables |I have contain duplicates.
  7. P

    Using MSQuery To Bring Entries From Multiple Tables Together

    Hi, I am trying to create, using MSQuery in Excel, a single table which shows all entries for a single customer over the year. These entries will come from 12 monthly tables, on separate worksheets within the same workbook. However, I am having trouble joining the tables, as when I try to do...
  8. N

    CHOOSE function with multiple tables and multiple columns

    I am trying to complete a form that extracts information from multiple tables with several columns. The column index is rarely the same, so I can't just hard code a column index number. I tried using the INDEX with MATCH functions to replace the column index number, but #VALUE error appeared...
  9. F

    Pivot Table / Powerpivot Calculated Column and Drill Down

    Hi Everyone, This is my first time posting, so please excuse any accidental forum faux pas. I am trying to create a pivot table that summarizes how many parts remaining at each process sequence. Ideally, when it's complete it'll also be able to drill down on each sequence to see the number of...
  10. M

    Creating a table from multiple PivotTables usable for making a report sheet

    Hi Excel Forum, this is my first post. I'm in deep need of help. I work as a student helper, and my job is to create reports for each of the departments of the school I work for. These reports include showing the changes in Headcounts from quarter to quarter and the distribution of the...
  11. B

    PowerPivot - New Measure - Calculated Field - Two Tables

    Hello, I am using Excel 2010 and have difficulties to do a calculation (whether using measure or column). My database is as follow: I have two tables: System_1 and System_2 Each table has several accounts (rows) with a specified value (column) The tables (or systems) are not the same - the one...
  12. D

    A Quick Way to Make Relationships?

    Hi Everyone, Just starting out with Power BI and I have a question. I've got a large amount of data in a large number of tables in Excel which I've imported into Power BI. All these tables have a time column and another column that contains values for a specific measure. All these time values...
  13. L

    VBA - Hiding and Unhiding numerous rows based on numerous cells

    Hi, I'm new to VBA and Macros so apologies for that! What I have managed to achieve so far based on online forums and guides, is to hide or unhide a column and 'rows in a different sheet' based on a data validation selection in a cell. Example: <tbody> Stages Yes or No Stage 1 Yes Stage...
  14. A

    State table - Should I use the State Abbreviation or a Autonumber for the Primary Key?

    I have a Customers table that holds a customer account number, Customer name, Street, City, State, Zip. I want to make a lookup table for City and a lookup table for State. Should I use the State Abbreviation for the Primary Key or an Autonumber?
  15. A

    Importing data to Access database with lookup tables

    I am fairly new to Access but starting to get the grasp of it. I am creating an Access database and I need clarification on using lookup tables. I import an excel file once a week to a temporary table. From there, I append the data to the main tables to seperate the information accordingly. I...
  16. A

    Should I be using 1 table or Multiple tables?

    I work in the financial industry and have been tasked to create a database for the department I work in. We will be importing certain financial transactions into this Access database which will store the following information: Customer Name 1, Customer name 2, Adress, City, State, Transaction...
  17. J

    Summarising Multiple BOM Tables into one - best solution?

    G'day folks, So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...
  18. K

    Crosstab Query with data from two tables

    I am relatively new at working with queries. I have two tables, one with realized expenses fro certain months and another with budgeted items for certain months. I am trying to create a query which will take all the expenses, put them into the categories I have them labeled under and sum for...
  19. F

    FlagInFormula_Create sumproduct formula to replace column in table

    Hi, (First post. Have not yet figures out how to attach example-spreadsheet.) I have a problem trying to incorporate a formula into sumproduct formula. In one table (TableBOSales) I have four columns (År Måned, SAP Avdelingsnummer, Antall, and Flag 1). The flag column matches identifier to...
  20. H

    Import Sheet2, Sheet3, and Sheet4 into Existing Access Tables

    As the title states, I am trying to import and append multiple sheets from a single excel file into tables in my Access DB. The excel Sheet2 will always be appended to Access table1, Sheet3 will always be appended to Table2 and Sheet4 will always be appended to Table3. The sheets in excel...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top