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

    Validating data with a list (formatting list question)

    Thanks you Hui, This will lead to have the full value (code + explanation) in the cell. I want only the code in the cell without adding an helper column. I was wondering if this exist in Excel (even VBA). Cyril
  2. C

    Validating data with a list (formatting list question)

    Happy new year to all, especially Chandoo with his "upgraded" familly :-) I want to allow the user to select a value in a list for a range of cells, but I want the list to be displayed the following way : CODE1 - Explanation 1 CODE2 - Explanation 2 ... Codex is the value in the cell...
  3. C

    Question about import.

    Hello all, Fortunately I've found something that helped me a lot. Look at : Workbooks.open( filename := xxxx, Local:=True ) The same applies to SaveAs. Then I use Microsoft Query to format my string properly, and now I've got : 2009-08-04 2009-08-03 2009-08-03 2009-08-03...
  4. C

    Graphics : Sharing Data on Facebook

    at least, there should be one !!! :-D
  5. C

    Graphics : Sharing Data on Facebook

    http://mashable.com/2009/07/20/facebook-sharing-data/ I think this one is an ugly pie-chart. I spent 5 minutes guessing where's Facebook.
  6. C

    Question about import.

    Thanks Chandoo for your answer. Unfortunately I've no control over the file generated. I must process it "as-is". The text written in the file is french-formatted correctly. Excel want to change the format of its own will. (weird isn't-it ?) I've already used the QueryTables.add function...
  7. C

    Question about import.

    Hello everybody here at PHD. I'm a bit stuck with Date format while importing CSV files, and / or copying the data. Here's what I try to do. Consider 2 bug defect systems capable to export to CSV (tab separated). The structure of the data is like this : System 1 : Bug ID1 / Author /...
View older results
Back
Top