Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    1,145

    I hope I got it right. Included are two options,...

    I hope I got it right. Included are two options, one with cells filled conditionally and other using stack chart. hope it will help.
    see attached. 34412
  2. Replies
    5
    Views
    1,145

    if I understand this correctly you don't want to...

    if I understand this correctly you don't want to change cell's appearance but want some sort of object to change color depending on cell value instead? if yes you can do this using stack chart. let...
  3. Replies
    5
    Views
    2,385

    Thank you for this, much appreciated. It will...

    Thank you for this, much appreciated. It will save me a lot of fiddling.
    I am quite surprised that the codes look soooo different from each other, especially the overwrite part. Anyway, great stuff....
  4. Replies
    5
    Views
    2,385

    Hi Roy, This is absolutely fantastic! Thank...

    Hi Roy,

    This is absolutely fantastic! Thank you very much!

    Can I be a bit cheeky and ask for a slight addition to this code? Can it also delete rows where column D reads either "EAA" or "TOC"...
  5. Replies
    3
    Views
    873

    Never ever have I seen or heard about windows...

    Never ever have I seen or heard about windows update causing such issue. I would advise you to check for some kind of cheeky vba code that perhaps embedded itself into your excel and is closing the...
  6. Replies
    5
    Views
    2,385

    Conditional find and replace/overwrite VBA

    Hi Guys,

    I am trying to write a macro that can overwrite certain cells with a specific value. The overwrite should be triggered by a particular value in corresponding cell from another column....
  7. Replies
    3
    Views
    569

    have you checked your axis options? are they auto...

    have you checked your axis options? are they auto or fixed? this might just be the problem here
  8. Thread: Updating Links

    by jckplck
    Replies
    3
    Views
    311

    Hi, From what I know this error message...

    Hi,

    From what I know this error message appears only when link reference no longer exists. Misleading in here is that when you open the source file first, the error message does not appear, but...
  9. Replies
    11
    Views
    873

    =ROUND(J22*1.1,0) =ROUND(J26*1.1,0) and...

    =ROUND(J22*1.1,0)
    =ROUND(J26*1.1,0)

    and format your cells to show no decimal places

    you can also use ROUNDUP(rounds number away from zero) or ROUNDDOWN (rounds number towards zero) in this...
  10. Replies
    11
    Views
    873

    :) happy to help

    :)
    happy to help
  11. Replies
    1
    Views
    297

    Just a blind shot coz I don't see data. Try with...

    Just a blind shot coz I don't see data. Try with =left(<cell with date>,10) then format formula result as date.
  12. Replies
    10
    Views
    2,358

    This is proving to be quite a challenge. For...

    This is proving to be quite a challenge.

    For some reason it does not like date format. Here's how I managed to work around it, follow the steps below and it should work - hopefully
    1. Insert...
  13. Replies
    17
    Views
    8,113

    sure thing

    sure thing
  14. Replies
    10
    Views
    2,358

    Had a chat about this code with some clever clogs...

    Had a chat about this code with some clever clogs but it seems that the matter is more complicated than I thought. Try not to filter pivots manually and it should work just right. See v3 of your...
  15. Replies
    11
    Views
    873

    Do you need to show different (increased by 10%)...

    Do you need to show different (increased by 10%) figures anywhere else? C33 or J33 perhaps? if not here is the spreadsheet with some simple formulas in indicated cells. Let me know if you need...
  16. Replies
    17
    Views
    8,113

    Well... Copy 2 was a bit of a hit and miss I...

    Well... Copy 2 was a bit of a hit and miss I think. I thought that I fixed the validation issue as it worked for me but am not sure if it worked for him though. Changing the code from macro to...
  17. Replies
    11
    Views
    873

    Hi I really like Verada's idea of using...

    Hi
    I really like Verada's idea of using =column() rather than putting column numbers but since you "don't know much about formulas" I fear that it might be no or little use to you.
    Correct me if...
  18. Replies
    17
    Views
    8,113

    Guys, I cannot send you private messages so I...

    Guys,

    I cannot send you private messages so I am hoping you will see this post.
    I am trying my best to help one guy who wants multiple pivots to be controlled with a single cell. I got it...
  19. Replies
    10
    Views
    2,358

    Try this version. data validation should work on...

    Try this version. data validation should work on this one here 34058
  20. Replies
    17
    Views
    8,113

    I see what you mean guys. As things stand I will...

    I see what you mean guys. As things stand I will be the only person using it but perhaps for future reference it would be good to safeguard it somehow. Sadly I have no Idea where to start. Can you...
  21. Replies
    10
    Views
    2,358

    Wow, it took me a while before I realized that...

    Wow, it took me a while before I realized that your date format is mm/dd/yyyy :). Anyway, see if the attached spreadsheet solves your problem. To stop you from entering wrong date into cell A1, I...
  22. Thread: stack chart

    by jckplck
    Replies
    1
    Views
    279

    34040 See if this helps

    34040
    See if this helps
  23. Replies
    17
    Views
    8,113

    Jeremy, Thanks a lot! It works perfect. I'm...

    Jeremy,

    Thanks a lot! It works perfect. I'm amazed by how little code it needs! I have loads to learn :) Thank you
  24. Replies
    10
    Views
    2,358

    I am guessing you would like to have a cell with...

    I am guessing you would like to have a cell with a drop-down that would control the pivots ?
    It can be done with a little piece of VBA code. Please see below, this one works with three pivot tables...
  25. Replies
    4
    Views
    401

    Hi You have to include workbook name in the...

    Hi
    You have to include workbook name in the series value. instead of DailyNewLikes_Range put ='Sheet1'!DailyNewLikes_Range that is if your workbook name is Sheet1

    that should do it
Results 1 to 25 of 29
Page 1 of 2 1 2