Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    221

    Subtotal in Pivot calculated field

    Hello,

    Is there a way to display Grand total in calculated field in PIVOT in columns (but display grand total of rows)? This grand total should show TOTAL value of all visible (filtered) values. I...
  2. Replies
    2
    Views
    122

    Re: Row subtotal in Excel Pivot

    In any case I am missing 1 subtotal, if I drop a filter. Here's the case in more details:
    in Rows I have Country, Category, Product group.
    Then in totals I can see: by country, by category within...
  3. Replies
    2
    Views
    122

    Row subtotal in Excel Pivot

    Hello,

    I have this pivot table which has 3 attributes in Row section: Category, country, product.
    What I need to do is that in that same Pivot table at the bottom totals appear which show Grand...
  4. Replies
    11
    Views
    9,282

    Re: Dynamic Query path (Power Query)

    Works like a charm (the second option)! Thank you very much!!!
  5. Replies
    11
    Views
    9,282

    Re: Dynamic Query path (Power Query)

    Hi billszysz,

    thanks for your reply. Could you please help me a little bit with tweaking the PQ Query? It's completely dark forest for me :) Before making any changes (and everything is working...
  6. Replies
    11
    Views
    9,282

    Dynamic Query path (Power Query)

    Hello,

    Is there a way to set dynamic querry paths in Excel? Example:
    I have a Master file which uses connections to 3 files which all have the same structure. The reason there are 3 files is...
  7. Replies
    2
    Views
    579

    Find text within a table

    Hello,

    I am trying to write a formula, which gave me the address of a cell which contains specific text. Example:


    <tbody>

    A
    B
    C
  8. Replies
    1
    Views
    233

    Dynamic linked table

    Hello,

    I want to make a table in Sheet1 and make a direct link of that table in Sheet2. Any changes in Sheet1 should reflect in Sheet2. Even if I add additional columns or rows, everything should...
  9. Replies
    4
    Views
    1,988

    Re: Cell color change without macro

    Hello,

    thank you both for replying!
    Special-K99, I want to highlight cells based on selection; so I guess I should use VBA..

    jeffreybrown, your solution highlights A1:B3 (or any other range,...
  10. Replies
    4
    Views
    1,988

    Cell color change without macro

    Hello,

    is there a way to change cell color on certain cell selection without performing a macro?
    For example, when I select any cell on column D, I need cell range A1:B3 to highlight in any...
  11. Replies
    0
    Views
    83

    Stacked chart using picture

    Hello,

    I am working on a price structure of some product and want to represent what creates a total price using a stacked chart. Nut instead of using boring colored chart, I want to use a picture...
  12. Replies
    5
    Views
    207

    Re: 4 is more than 5??

    Hey guys,

    thank you very much for help!
    I also figured out, that I could just use VALUE function to convert the string I received from using RIGHT to number.
    CEILING is also a great solution!...
  13. Replies
    5
    Views
    207

    4 is more than 5??

    Hello,

    I have this strange issue when I try to round up all the figures 1-4 to 5. Let's say I have a value of 6.74 in cell A1 and want to round it up to 6.75. I use a function in A2:

    But the...
  14. Replies
    1
    Views
    318

    Show/hide text box on cell select/deselect

    Hello,

    maybe anyone of you know the solution to my problem? I need this:
    1. When you select a certain cell (let's say B2), text box pops up; which allows you to insert/edit comment.
    2. When you...
  15. Replies
    6
    Views
    302

    Re: Workbook name with space in it

    So there is not easier walk-around for this?
    Thanks!
  16. Replies
    6
    Views
    302

    Re: Workbook name with space in it

    Yes, in this particular case it workbook 2007 Excel to 2003 workbook. Didn't think of that. Is there any walk-around?
  17. Replies
    6
    Views
    302

    Re: Workbook name with space in it

    Thanks,

    but it still gives me error. Run-time error 1004. "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To...
  18. Replies
    6
    Views
    302

    Workbook name with space in it

    Hello,

    I have this problem with setting Workbook's name which contains a space in it as a string, and then using it again. I always get out of range error. The example:
    Workbook name is...
  19. Replies
    3
    Views
    266

    Re: Cancel form initialization

    rorya,

    thanks! worked just fine!

    VoG: I did perform error check, but it does not allow unloading the form on initialize event.
  20. Replies
    3
    Views
    266

    Cancel form initialization

    Hi guys,

    I have a user form which adds values from a dynamic range when initializing to control boxes. But if the dynamic range is empty, then there is an error when the user form is initialized....
  21. Replies
    4
    Views
    417

    Re: Calling user form on another workbook

    Thanks!
  22. Replies
    4
    Views
    417

    Re: Calling user form on another workbook

    Could you please write a code to run a macro from another workbook?
    On the one, which has that form I want to show, I have created a Public Sub.
  23. Replies
    4
    Views
    417

    Calling user form on another workbook

    Hi guys,

    I have searched the forum as well as google, but could not find explanation to my problem.
    Currently my macro copies some information and pastes it to another workbook which has a...
  24. Replies
    1
    Views
    531

    .eps form in excel

    Hi guys,

    a designer has created us a form so we could print some papers with company's logo etc. and then use it for invoices or other documents. The form is in .eps format.
    Is it possible to...
  25. Re: Getting cell address depending on user input

    just found a good thread about my problem :)
    http://www.mrexcel.com/forum/showthread.php?t=249264
Results 1 to 25 of 73
Page 1 of 3 1 2 3