join tables

  1. M

    VBA code for copying and combining data from 2 sheets (joining 2 tables into a new one)

    Hello, I am looking for some help with my little challenge. I am trying to combine data from 2 different sheets in an automated way, but I don't know VBA and macro well enough to get this to work without help. I have 2 sheets and I want all the combinations from the to sheets to be copied to...
  2. 2

    Join Tables

    Hello Friends Could you please help me with VBA Code for joining two tables on a common column and then generate a third table. Both the tables are on a separate worksheet and the result table needs to be on a separate sheet as well. I can easily do this using Access but my requirement is to...
  3. A

    Crazy Data Aggregation Question

    Hi All, You have helped me out tons in the past with some of my Excel mindbenders and here is another one if anyone can help! I have 100+ worksheets spread across about nine workbooks with data that needs aggregated together. Each workbook has identical fields between its own worksheets, but...
  4. W

    Query trouble, Redundant data with table joins and date selects

    (Access 2007) I have three tables in a database: tblClients, tblOfficeVisits and tblData tblClients has a primary key CaseID. This is joined (inner, 1-Many) to CaseID in tblOfficeVisits which contains only three fields (CaseID, VisitNumber and VisitDate). The purpose is to list every time a...
  5. C

    Joining Tables on External Data Source with Pivot Tables

    Hi...I am trying to query data from 4 different tables. I originally tried the code below but it did not work: Sub SQLQuery1() Uname = sheetMain.txtUNAME Pword = sheetMain.txtPWORD DBASE = "ZET" Sheets("Bill Determinant").Activate Range("A3").Select SQL1 = "BD.CALC_LEVEL...

Some videos you may like

This Week's Hot Topics