• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Variable Month Formula

    Yeah so far its working OK, but thanks for bringing an alternative to my attention
  2. A

    Variable Month Formula

    Narayan, Thanks for the question. The main reason I constructed the formula(s) the way I did was to avoid value errors and to have the range blank when there is no data. Your first formula: IF(F13<=0,G12,G12-F13) did not accomplish this goal The 2nd one: IF(OR(C17="",D17=""),"",D17-C17+1)...
  3. A

    Variable Month Formula

    oh sorry I thought I did upload it
  4. A

    Variable Month Formula

    Hello All, I am working on a project that involves tracking a credit. The tool uses data validation to trigger certain functions within the formula that I am being challenged with. This is the formula...
  5. A

    Non - Manual Formula Fill

    Kanti, Thank you very much... with a little restructuring I was able to convert the input area to a table and this achieved my desired outcome. Thanks for your time!!
  6. A

    Non - Manual Formula Fill

    Narayan Thanks for your reply. The sheet is under development. The structure will be evaluated for more continuity once I get the basic functions worked out. With respect to your question, H6 is for reference only... but part of the formula you mentioned will equal H6 ... ($H$4/30.416). Users...
  7. A

    Non - Manual Formula Fill

    Happy New Year to All. I have been searching the forum for a solution but to no avail. I am looking for a way to have a series of formulas in a row automatically fill downward was data is entered into a subsequent row. I am working on a tool that will track payments(see attached). The data...
  8. A

    Your favorite Excel feature...?

    Data validation, named ranges, and advanced filter
  9. A

    Controlling Tab Order

    Luke, The code worked perfectly.. Thanks Again !!
  10. A

    Controlling Tab Order

    Luke, Thanks for the link. I will try the code and see if it works. I will bookmark this site as well for future reference....AWESOME! SirJB7, I appreciate your suggestion. I previously tried to uncheck the box under protection but the tab order I get is B13-E13.... I need it to go B13-B37.
  11. A

    Controlling Tab Order

    Hello Friends I have a question about controlling the tab order in a protected worksheet. The cell order is non-contiguous. I would like the user to tab in this order; "B13", "B14", "B15", "B16", "B17", "B18", "B19", "B20", "B21", "B22", "B23", "B24", "B25", "B26", "B27", "B28", "B29"...
  12. A

    Congrats to new ninja, BobHC!

    Congratulations Bobhc
  13. A

    Automatically expand merged cells multiple sheets

    Luke, This may be a stupid question, but where would the one-liner go? As I mentioned I am very new to VBA. I have worked with a few macros which I assigned in modules. I then created buttons to execute the code. What your suggesting seems different than that. Once the one-liner is placed...
  14. A

    Automatically expand merged cells multiple sheets

    Thanks Luke, My research of this topic finds the same recommendation against merged cells, but I did not know why, thanks for your added insight. I will work with changing the formatting as you suggest as this seems to be the most efficient way, and because I am very new to VBA and want to...
  15. A

    Automatically expand merged cells multiple sheets

    Hello Friends, I am looking for a solution that automatically expands merged cells for multiple sheets; 1,2 I am working on a project that requires user input on sheet 1 in merged cells;C14:G14. My 1st challenge is to have the merged range expand automatically as the text expands. Part 2...
  16. A

    Congratulations Luke - 3000 Posts

    Luke congratulations, I echo kaushik03' sentiments. You are truly an asset to this community!
  17. A

    Hiding Rows/Range based on criteria

    Narayn, The code was exactly what I needed. I am reading john walkenbach's book on VBA to try to learn this aspect of programming. I appreciate your help in getting through this challenge!!
  18. A

    Hiding Rows/Range based on criteria

    Hello, 1st I'd like to thank you for your time I really appreciate it. I'm on my way to work but will give the code a try when I get home this evening and let you know.
  19. A

    Hiding Rows/Range based on criteria

    Hello Narayank991 The cells that are merged are as follows; B4-C4 B13-C13 B18-C18 B22-C22 B27-C27 B41-C41 B45-C45 B55-C55 Thanks for the tip on shortening the code I will work with it.
  20. A

    Hiding Rows/Range based on criteria

    Narayank991, I took some of your comments and came up with the following that seems to work pretty well Sub Hide_Rows() If [b4].Value = 0 Then Rows("4").EntireRow.Hidden = True If [c5].Value = 0 Then Rows("5").EntireRow.Hidden = True If [c6].Value = 0 Then Rows("6").EntireRow.Hidden =...
  21. A

    Hiding Rows/Range based on criteria

    NARAYANK991, I'm not quite sure how to answer your question. The ranges above are input ranges...there are many merged cells ie ("B4:C4") in the range area. So I guess I would need a procedure( macro) that considers the ranges as outlined above, and if blank hide the corresponding row. I...
  22. A

    Hiding Rows/Range based on criteria

    SirJB7 Thanks for your post, and I appreciate your comments. With regard to your comment about this post being a variation or extension. I am not sure if this would be considered either... my bad if it was.. this is how I considered the issue. The post...
  23. A

    Hiding Rows/Range based on criteria

    I am asking for help with a VBA solution. I have researched this forum and the interweb in general, and cannot seem to find the exact solution. The short version of my problem is I have a workbook sheet that is filled out by co-workers. I would like to hide rows that are left blank. Below are...
  24. A

    Macro Confirmation

    No problem
  25. A

    Macro Confirmation

    SirJB7 I didn't see your post.. thanks so much!!! I was wondering if there was a way to shortened the code and you provided it. I see you used the term "union" which I will research.. thanks again friend!
Back
Top