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!

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

Search results for query: *

  • Users: pkhoo
  • Content: Threads
  • Order by date
  1. pkhoo

    offset with reference to unopen spreadsheet

    hi all, need your help here... i have an offset function with reference to an unopened spreadsheet. It comes back with #value! msg. If the spreadsheet is open, then the formula works. both spreadsheet are on the same directory. I am running excel 2000 sp3. APPRECIATE ANY HELP YOU CAN...
  2. pkhoo

    OpenRecordset returns type mismatch error

    help!!! The line below "error here" is using the openrecordset method to return a record set. However, it merely returns a "type mismatch" error instead. Any suggestions would be helpful. I had looked at the references and found the following: Visual Basic for...
  3. pkhoo

    can you unique count in a pivot table??

    For example, region Cust id Product A 21 a1 A 21 b2 B 21 a1 B 21 b2 I would like to see region count of cust A 1 B 1 thank you in advance
  4. pkhoo

    pivot table dropdown doesn't trigger worksheet_change

    Hi i am new to Excel VBA but have some experience in Access. I have a macro that will update the dependent pivot tables base on the first one using the worksheet_change trigger. However, when the pivot page dropdown was change, it didn't work - only if other cells was changed. If I use the...
  5. pkhoo

    link two pivot tables together

    i am trying to link two pivot tables together so that when the page field of the first changes it will change it for the second. any ideas? not familiar with VBA but will try anything.

Part and Inventory Search

Back
Top