Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jnevi

  1. jnevi

    Join 2 pivot tables with 2 different data sources

    Yep, that was it PHV!!! But now there is something else... I think it would be good to sum things up again too. How It Should Work: There is a combo box at the top of the worksheet - It contains a dropdown list of all the project names. The numerical value in cell X1 corresponds to a project...
  2. jnevi

    Join 2 pivot tables with 2 different data sources

    It doesn't like my IF statement. Error 438: Object doesn't support this property or method for the highlighted part. With ActiveSheet.PivotTables("Table 2").PivotFields("Project") If Not .PivotItem("Project 1").Visible = True Then PivotItems.Visible = True For Each pItem In...
  3. jnevi

    Join 2 pivot tables with 2 different data sources

    I get this error Skip: Run-time error '13' Type Mismatch For Each pItem In ActiveSheet.PivotTables("Details").PivotFields("Project").PivotItems
  4. jnevi

    Join 2 pivot tables with 2 different data sources

    Hi Skip, I've also been requesting help with this issue on another board: http://www.mrexcel.com/board2/viewtopic.php?p=1273416#1273416 I just can't get this to work. I decided on the method illustrated in this clip...
  5. jnevi

    Join 2 pivot tables with 2 different data sources

    I need help my friends. Can't figure this out. I have 2 pivot tables on a single worksheet. Each table has its own data source - 2 different databases (had to set it up that way to present all the data requested). The 2 data sources have one column of data in common. This column is called...

Part and Inventory Search

Back
Top