• 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. V

    Value returns value of 1 not zero per formula

    ... that fixed +1 always adds +1 others J-column formulas do not have that parameter.
  2. V

    Value returns value of 1 not zero per formula

    Tokkelosie Do You mean cell J6 case? ... for some reason, there is fixed +1 in the end of that formula.
  3. V

    Fill colour based on dropdown list selection

    Calypso88d Sheet1-sheet use DropDown Rules-sheet apply rules - with C-column can set color too.
  4. V

    Fill colour based on dropdown list selection

    As two times tried to get an answer: how do You manage those missing rules? Without an answer ... it's really a challenge to offer more than those ... Your given rules.
  5. V

    Fill colour based on dropdown list selection

    Calypso88d Do You know those rules - how that file should work? Which dropdown value column value combination should give which color?
  6. V

    Fill colour based on dropdown list selection

    Calypso88d I referred only and only Your given file. otherwise ... ... how do You manage those missing rules? It'll be a challenge to offer any kind of solution if something basic details are missing.
  7. V

    Fill colour based on dropdown list selection

    ... the only two rules, yes Means that only those three labels and only those four columns can have colors - others ... no! You haven't use third label ... that means - no color. As well as Apples won't have color.
  8. V

    Compile error as variable has not been created yet.

    Esrasnatas About Your Dim Sht_58_Data As Worksheet Sht_58_Data.Activate What is She_58_Data's value? ... same as ... which sheet You would like to Activate? Have You Googled eg Excel VBA Dim? ... to check some basic rules - how do Excel work?
  9. V

    Fill colour based on dropdown list selection

    Calypso88d This thread can move to VBA Macros ( ~no need to open a new thread ). Your I have 89 labels in the dropdown list and more than 20 columns eg Grapes, Oranges, Bananas and Your file shows ... two rules for those colors. Are those all rules? if Yes then okay otherwise ... ... how do You...
  10. V

    How to Keep/Retain leading Zero’s when I Save as a .CSV file

    ChaCha90 You offered here csv-file. Where do You get those datas there (in .csv-file)? If You'll get those datas somewhere else than from ... csv-file, then please upload here a sample Excel-file which You should save as .csv-file with leading zeros or so.
  11. V

    How to Keep/Retain leading Zero’s when I Save as a .CSV file

    ChaCha90 I opened Your file and it asked as below ... I selected Don't Convert ... It opened with leading zeros. I saved it as .csv ... and Your file looks same as Your original. Have You tested as above?
  12. V

    Would like to calculate assay volume for each assay for 12 months /Clinic A

    stanley thomas Moderator Note: These Forum Rules are for everyone: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a...
  13. V

    Saving as cell values

    Artisez About Your During the weekdays we will save a backup copy and add the... Questions: Could this backup procedure do automatic? Why You or Your boss would like to apply some cells and press the button? Solution: That procedure could happen while opening/closing file by the code. There...
  14. V

    Construction Budget distribution using GAMMADIST Function

    ibrahimdaas Your What is requered from me to do ?? #1 before posting, You read Forum Rules #2 post Your thread #3 follow rules #4 be patient, others will reply then they'll have time Your thread It would be possible ( You could test with Your used functions ) to get differences to zero like...
  15. V

    Saving as cell values

    Okay #1 If Your cells F2, P1 & Q1 contains texts as You wrote then there are invalid characters. I try one more time and other way: if You select cell F2 ... what can You see in formula in Excel formula bar? and do same with cells P1 & Q1. #2 Length of path & filename? #3 Did You modify variable...
  16. V

    Saving as cell values

    Verified means that You've checked/verified that those three values are valid for filename... as written in that Run-time error. How long is path & filename? Your the 1st parameter (filename) is same as Your variable filename ... it would be better to have different variable name
  17. V

    Saving as cell values

    Artisez What are verified values for value1, value2 & value3?
  18. V

    Construction Budget distribution using GAMMADIST Function

    ibrahimdaas As You've read from ... many Forums: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker. If you...
  19. V

    Add filter in pivot table

    aayu Please, do not duplicate Your thread. https://chandoo.org/forum/threads/add-filter-in-pivot-table.56409/ Continue with Your previous one. This thread is closed now.
  20. V

    Weight Scale Chart - FunChart

    mgangs Did You check that file? ( #10 reply ) Did You check blog? ( #11 reply ) If You'll have still more questions ... ... then open a new thread.
  21. V

    Sumifs between two dates

    Vikas_Salvi It could work after You've changed those text-dates ( $B$1:$M$1 and $B$3:$M$3 ) to dates.
  22. V

    Excel VBA: How to create a dynamic skyline chart based on filtered range

    Rupesh.Sawant As written 'Skyline'-sheet was like empty. > #1 reply file uses formulas, which needs 'newer' version of Excel. > #2 Enable macros.
  23. V

    Using Office 2010 VBA In Office 365 Will Not Work

    MrProfessor As You've read from two sites: Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker. If you do cross-post, please put that in your post. Also if you have cross-posted and...
  24. V

    Using VBA to restrict pivot table changes - reordering all columns and rows

    So ... protection works 'too well' with Your case. Could You create a sample Excel-file, which shows # what do You really would like to allow? # what do You really would like to restrict? Or Could You add eg to the 1st row of that sheet values from 1 to 9999 ( = number of columns ) ... and take...
  25. V

    Using VBA to restrict pivot table changes - reordering all columns and rows

    raaaaaaah Have You tested sheets protection option?
Back
Top