• 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

    Combination of rules for data validation formula

    lastkoz Against paste... If the yellow sticker in the upper corner of the monitor is not enough, then I would try to use VBA to take care those.
  2. V

    Conditional Formatting

    Shabbo My Excel give one minor note ... but could You use something like this?
  3. V

    Combination of rules for data validation formula

    Something like below?
  4. V

    Gantt Chart

    DirkT I've tested it few times ... there could be some unwanted features. My writing Insert new rows ABOVE this one-option won't work -- means -- it won't work - because this sample uses fixed range. There are some code for that.
  5. V

    Converting a multi-line pdf to excel

    jeanmarcd Your I need the pdf file to convert to an excel file where each line of the multi-line cell is in its own cell / line. Could You send a sample PDF-file ... instead of Excel-file? ... as You've written.
  6. V

    Gantt Chart

    DirkT Okay... Few minor notes ... # it's very sensitive with those colors # dates will refresh after You've moved cursor # Display week ... changes calendar ... project itself stays in same place (~move) # I added [ ReFresh All ]-option to refresh all rows (8... 31) # So far Insert new rows...
  7. V

    How to group data from multiple sheet

    Luca999 Okay ... none questions. Few same notes: # 'grouping' is missing as I wrote # my eg ... You answered something else # That file needs many modifications.
  8. V

    Gantt Chart

    DirkT Could this sample work someway as You've thought? # Select cell # Mark cells (~bars) with colors (which are very sensitive) # Move Your mouse somewhere % and dates should update
  9. V

    How to group data from multiple sheet

    Luca999 There are still too many 'how this should work?'-cases ... before I could figure - how/which to group something? ... plus many more eg how any 'equipment' could give 'Final Country'. There should be clear connections between those which could group. I did 'minor' modifications to Your...
  10. V

    How to group data from multiple sheet

    # grap ... yes? ... and have huge file. As well as there are some dropdowns. Skipped question: How You control that data is there once? # Naming ... really? check below snapshot ... hmm? Did You follow 1155? Do it matter if there will lost some connections with sheets? # number of those...
  11. V

    How to group data from multiple sheet

    Still too many ... hmm? # grap ... yes? # Naming ... really? check below snapshot # number of those interventions ... are different than You wrote or how?
  12. V

    How to group data from multiple sheet

    Three questions ... You answered to the 1st one. but Only Sheet3 has ID information. If follows Sheet1's JOB 1155, which have three places for intervention. from Sheet2 can find three rows data based REFERENCE JOB 1155, which each have ? separate ? three places for intervention - total nine or...
  13. V

    How to group data from multiple sheet

    Somewhere is possible 3rd intervention too ... hmm? ... where? Do You really have already three times same data? ... or How You control that data is there once?
  14. V

    How to group data from multiple sheet

    Luca999 Isn't Your 4th sheet layout still horizontal? If You want to avoid see some columns then those columns could hide for those moments Or Do You have an image to show possible 2nd intervention below 1st intervention? ... then do You really need to see those A...E-columns twice?
  15. V

    How to group data from multiple sheet

    Luca999 Your 3rd sheet has two extra columns (TYPE & OVERALL STATUS). ... plus there are two times those seven columns. Why You won't use it? ... or what to do with those other seven columns. You sample data has many empty cells. Is Your 4th sheet ... vertical? ... is something else then please...
  16. V

    VBA, Macros for Solver

    Yash0071 As You've read all links from https://chandoo.org/forum/forums/new-users-please-start-here.14/ You've found page https://chandoo.org/forum/threads/posting-a-sample-workbook.451/ You've found one way - how to use code - tags.
  17. V

    Copy paste one sheet to another sheet

    Sairavindra As You've asked this in Ask an Excel Question Do below: Select Sheet1 Select left top corner Press Ctrl+A Press Ctrl+C Select Sheet2 Select cell A1 Press right button of mouse Select PasteSpecial Select Transpose
  18. V

    Calculating late hours exceeding the 24 hours

    Juniad cell AI3 =SUMIFS(E3:AH3,E$1:AH$1,"In",E3:AH3,">"&TIME(8,0,0))-COUNTIFS(E3:AH3,">" & TIME(8,0,0),E$1:AH$1,"In")*TIME(8,0,0) and copy down
  19. V

    convert excel file to text file

    I use normally with sheet-module. It's possible to search many thing from Google, but that other , which name I skip ... I recommend to forget.
  20. V

    convert excel file to text file

    Did You test my file? Did You check that my code? That uses only Your named SomeSheetOne-sheet. ... of course, before testing something - have a backup!
  21. V

    convert excel file to text file

    prabirmustafi Why do You need to copy that sheet? Copy needed range as in my sample. Compare to this sample. From where do You have idea to run that my code? If in other file than that ... sheet is then ... something different.
  22. V

    simplest way in Excel to combine (merge)

    ValentinCVE You could get some possible way after You've sent a sample Excel-file as well as expected correct result based Your sample data.
  23. V

    convert excel file to text file

    prabirmustafi I waited for a sample expected correct txt-file .... Here one sample (.xlsb-file ) to get txt-file (.txt-file) ... You gotta modify needed SaveAs line there.
  24. V

    convert excel file to text file

    expected correct txt-file.
  25. V

    convert excel file to text file

    prabirmustafi Have You tried to do it manually (those 7 steps)? Do it works then? Have You tried to record a macro with those 7 steps? ... What is different than You're needing? If You would like to ask about VBA ... then this thread should be in VBA Macros ( moved there ). Could You send a...
Back
Top