Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    174

    Re: Colour Pivot Filters When Active

    I've added the direct link to the zip file with the example below.

    https://www.contextures.com/FilterColour.zip
  2. Replies
    1
    Views
    174

    Colour Pivot Filters When Active

    My goal is to highlight the cell when I have a filter active in the pivot table row & column labels.

    I have found the linked document below which shows me how to accomplish what I'm looking for...
  3. Replies
    5
    Views
    16,251

    Re: Pivot Table Data Source - External to Internal

    I know this thread's old but it was extremely helpful and I didn't know what immediate window meant, so I thought I'd elaborate as I was caught up on step 3 for a few minutes.

    The immediate window...
  4. Re: VBA: Change Dim range to use text on active clipboard instead

    Thanks! I was able to get the value off my clipboard with the above code. Now to figure out how to put the 2 parts together.

    I may have to take the easy route and paste the value into a cell...
  5. VBA: Change Dim range to use text on active clipboard instead

    Hello,

    I need help slightly modifying some VBA code that I found in an old thread (Link to the old thread is at the bottom). This VBA is automatically changing the pivot filter based on the...
  6. Aligning time series with different start dates

    Hello all,

    I am struggling with aligning multiple sets of data with different start dates that I would like to compare so I can see the trends. I have thousands of rows of data, so it not a simple...
  7. [SOLVED] Re: VBA: Use macro to automatically format value field settings of pivot table to a single value

    Thank you, exactly what I was looking for. I appreciate your help and the pointers.
  8. Re: VBA: Use macro to automatically format value field settings of pivot table to a single value

    I don't really understand how to write macros with a Dim so the below code doesn't work, but may this will help you to see what I'm hoping for. Based on the text in the active cell, I want apply that...
  9. Re: VBA: Use macro to automatically format value field settings of pivot table to a single value

    Hi Jerry,

    Thank you! This is awesome and will be very helpful. I would like to take this a step further if possible. Is it possible to reference the data field by the current cursor location. So...
  10. VBA: Use macro to automatically format value field settings of pivot table to a single value

    Hello all,

    Currently I have the below code which is successful at formatting all the value field settings in the selected pivot table to my specified format. My goal is to be able to apply the...
  11. Solved Re: vba runtime error save as, need to run next macro in series

    That did the trick! Thank you for the help, much appreciated!
  12. vba runtime error save as, need to run next macro in series

    Hello,

    I have the below code with a simple save as command for my macro. The issue I run into is, if the file already exist and I choose "No" or "cancel" in the dialog box the code returns a...
  13. Re: Modify Prompt: The cell or chart that you are trying to change is protected and therefore read-only

    That seems to have done the trick! Thanks for the help!
  14. Re: Modify Prompt: The cell or chart that you are trying to change is protected and therefore read-only

    I believe its due to the formula in the cell. So say I double click on locked cell A9 with the reference formula '=DD9', which has a vlookup formula, once you hit okay for the prompt the sheet then...
  15. Modify Prompt: The cell or chart that you are trying to change is protected and therefore read-only

    Hello,

    I have created an application in excel for other users and have some cells locked on the protected worksheet so they can only edit areas that need to be changed for their use. I don't want...
  16. Re: Conditional Format across multiple cells with different refernce cell.

    Yes thank you two for the help, my issue was the absolute reference was causing it to apply the format to all cells rather that each cell individually.

    Thanks again!
  17. Conditional Format across multiple cells with different refernce cell.

    Hello,

    I want to apply a simple conditional format to a large number of cells.

    Format: if =F6<>U6 and apply this condition to U6

    I have a range of values like this, so the next in the...
  18. Re: VBA: Simple Macro Modification, Help needed

    Thank you to you both and for the fast reply! Works perfect!!
  19. VBA: Simple Macro Modification, Help needed

    Hello all,

    I found this macro below someone preivously posted and it works great, but I would like to change the macro to only make changes to the active sheet rather than the entire workbook and...
  20. Replies
    1
    Views
    221

    If function: search for text in formula

    Hello all,

    I am trying to create a function that will search for text within the formula of a cell, currently I have only be able to search the values in cells.
    ...
  21. Replies
    2
    Views
    9,569

    Re: Pivot Table Update Event

    That did the trick!

    Thanks for your help with this Jerry, greatly appreciated!</SPAN>
  22. Replies
    2
    Views
    9,569

    Pivot Table Update Event

    Hello,

    I am using the below code to run a macro in my workbook. My goal is to have the macro run once I change data in the report filter of my pivot table, the below VBA code works and runs my...
  23. Re: Clear values in cell range when updating pivot table

    Jerry,

    Thanks for your help. The problem was I had multiple VBA modules with "Private Sub" coded throughout. So after I deleted all the duplicate code everything worked fine.
    Then I entered the...
  24. Re: Clear values in cell range when updating pivot table

    Thanks for the help.

    I took your advice and used the Worksheet_PivotTableUpdate event, which will work great because I would like the range to clear anytime the pivot table is updated, I started...
  25. Clear values in cell range when updating pivot table

    Hello all,

    I am trying to create a macro using VBA that will automatically run when I update a report filter in my pivot table. My pivot table consists of a bunch of my companies item numbers and...
Results 1 to 25 of 25