• 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

    Copy data from ranges into on column

    Hi Claude, Don't know if this fits the bill or not but, how about this entered if F: =IF(A5="","",LEFT(A5,3)) Hope this helps shalom Auto
  2. A

    Drop down list options

    File sent as requested.
  3. A

    Drop down list options

    Knew it Was too good to be true. I'm getting a Runtime Error 13 Error. Private Sub Worksheet_Change(ByVal Target As Range) ' code provided by 'Chandoo.org(Hui) If Target.Address = "$D$9" And Target.Value = "HSR Health Safety & Regulatory" Then...
  4. A

    Drop down list options

    Hui Thanks a million. Just what was required. An Excel Ninja indeed. :=)) Auto
  5. A

    Drop down list options

    Thanks Hui! That's pretty much what I did. I'm now trying an "option" form control button but, I can't hide the buttons when the conditions are negative. Any thoughts? Failing anything else I'll stick with the first option. Thanks again! Auto
  6. A

    Drop down list options

    Hi Folks! I have a drop down list with four choices. If one particular choice is made then I would like a pop-up (or some other option)to ask a yes/no question which requires a response. Is this possible using data validation or conditional formatting or a combination of both? I'm even prepared...
  7. A

    Microwave Output Wattage Formula

    Thank you Hui! How did you know it was a chocolate cake :-) Auto
  8. A

    Microwave Output Wattage Formula

    First off Hi Folks! Now, not your normal Excel question I know. Does anyone know of a formula to convert microwave output wattage cooking times? e.g. from 700w to 900w There are a ton of sites offering tables and such but I'm looking for a universal formula. Any help appreciated.
Back
Top