Search:

Type: Posts; User: deadlyliquidx; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Connection String for MS query read only

    Hi,
    I am using MS query and SQL syntax to update a pivot that reads the worksheets sheets within the same workbook.
    Now I know that this works perfectly when the files that the query is reading...
  2. Re: Massive problem: Excel has found unreadable content.

    No it happens in alot of other computers in the office.
    Others have fixed this problem, I just need to know where to go to fix it.
  3. Massive problem: Excel has found unreadable content.

    Good Morning All!
    I have having a major issue with excel.
    Certain files keep saying Excel has found unreadable content, do you want to recover.
    And then when it repairs it takes away all of my...
  4. Replies
    3
    Views
    1,355

    Re: Advanced pivot table filtering VBA

    bumpity bump
  5. Replies
    3
    Views
    1,355

    Re: Advanced pivot table filtering VBA

    That didnt do it, I just literally need to tell my pivot table to not update when I choose a new dropdown filter. I can figure out the rest of the code from there.
    Like something on the private sub...
  6. Replies
    3
    Views
    1,355

    Advanced pivot table filtering VBA

    Good Morning All!
    So I have a pivot table connected to a database.
    Now I have three pivot tables, one for Year to date, month to date, and week to date.
    Now its a huge database so it takes a good...
  7. Replies
    2
    Views
    721

    Re: Log sheet to track changes in VBA

    That looks way too much from what im after and I cant even read it to fix it for my file.
    Anyways, this is what I have abet its a bit slow.
    Now I have a new problem, somewhat related, so you can...
  8. Replies
    2
    Views
    721

    Log sheet to track changes in VBA

    Hi there,

    I have found variations about my problem but not my exact issue.
    I need a log sheet that will log changes made on a tab called "Final" and log those changes in a tab called "log"
    I...
  9. Replies
    1
    Views
    252

    Re: Log changes made to columns VBA

    bump this bro!
  10. Replies
    0
    Views
    423

    VBA connect SAP to Excel

    My company recently uses SAP BI which we use online.
    We don't have the add on to excel installed.
    Our previous SQL system was easy to connect to and we used to just connect pivot tables to it and...
  11. Replies
    9
    Views
    1,648

    Re: Pivot filter VBA help!!!

    Can you show me the modification, i dont understand it.
    Thanks!
  12. Replies
    9
    Views
    1,648

    Re: Pivot filter VBA help!!!

    When I try your code, I get "no match found", maybe I am explaining this wrong.
    So basically I want to filter my OLAP pivot without having to individually select stores on the filter by having it...
  13. Replies
    9
    Views
    1,648

    Re: Pivot filter VBA help!!!

    But actually your idea is interesting for the future, I just don't know how to implement it to my sheet. I tried with the coding you gave.
    So say the Filter list as it is named on the physical...
  14. Replies
    9
    Views
    1,648

    Re: Pivot filter VBA help!!!

    Thanks but I already found a method that takes a list and changes slicers of an OLAP
    downside is I have to put the technical location location store name but it works perfectly without much...
  15. Create an array based on cell values

    Hello friends!

    I need to build an array based on a list in range A1:a300 on a sheet for a big code.

    sc.VisibleSlicerItemsList = Array(ActiveSheet.Range("a1"), ActiveSheet.Range("a2:a2"),...
  16. Replies
    1
    Views
    2,008

    Slicer Filter based on cell value

    Hello All,
    I have a code that filters a olap based pivot table Slicers based on cell values in column A.

    Sub SetSelection()
    Dim sc As SlicerCache
    Dim s As Slicer
    Set sc =...
  17. Replies
    9
    Views
    1,648

    Pivot filter VBA help!!!

    Hi all,
    I have never been confused in my life with VBA!! But first time for everything, if you guys get this, you would be gods amongst men.

    I am trying to filter an OLAP cube pivot table...
  18. Replies
    1
    Views
    252

    Log changes made to columns VBA

    Hi There!
    I need a VBA that will log any changes made on certain columns on a separate sheet automatically.
    For arguments sake lets say the columns that will have changes made is Columns A and C...
  19. Replies
    1
    Views
    277

    Countif Unique combination!!!

    Hey All,
    I need ONE FORMULA to be able to solve a problem that I have to find a product and color of product, and count it once if it shows up once in a span of 3 months but not count it if it...
  20. Re: Need to countif with no duplicates and greater than 0.

    Thanks alot, you guys are great
  21. COPY down formula if header has an X!! VBA HELP

    Hey guys,
    Basically I have a sheet that extracts data from another sheet based on an index-match formula.
    The data is massive and spans 1000 rows so it basically copies the index match formula...
  22. Need to countif with no duplicates and greater than 0.

    Hello Guys!
    I have a problem in which I need to count unique/ distinct (i dunno which one), values that do not duplicate and have a sold value greater than 0 for a certain month.
    Ex:

    ...
  23. Re: Sumproduct keeps giving me a problem, how can I formulate to skip blanks/errors

    I dunno what you guys are asking but I know the formula works given no blanks, errors are on the sheet. I just need the formula to skip errors you guys
  24. Sumproduct keeps giving me a problem, how can I formulate to skip blanks/errors

    Basically I am working with a spreadsheet with alotta REF!, NA, Texts and blanks within the data array and I dont have the time to manually remove them,
    how can I make this formula to ignore all...
  25. Replies
    3
    Views
    603

    Re: Sum multiple Index Match Lookups!

    this place doesent allow me to post books
    but here is an image
    http://s8.postimg.org/xrp8ahclh/Untitled.jpg
Results 1 to 25 of 27
Page 1 of 2 1 2