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

    Index match with a wildcard

    HI , I have a list of IDs number like S0001234AA to S0001234AZ from top to bottom in Column A .Actually the list consist of many Raw data From S0001234 and other IDs with additional alphabaet behind Such As S0001234AA-AZ , S0005678AA-AZ etc.. Now what I would like to do is using a vlookup...
  2. M

    runtime error..replace Application.filesearch to DIR

    Hi all, I know that if I had used Application.filesearch in excel 2003 and I upgrade to excel 2010 , the command will not works(Runtime error 445) I am totally new to Macro but I knows how to click debug and get a glimpse of how the code looks like..Could someone please teach me how do I...
  3. M

    Excel 2010 opens on Internet explorer instead of Excel 2010

    Hi all, I've search online for many means other than to editing the registry but is here any way to allows data to be download and opened in Excel 2010 instead of the internet explorer. I could do it in Excel 2003 but not 2010 and I can't and are quite unwilling to edit the registry as it is...
  4. M

    Auto Running Macro at fixed time.

    Hi , i would like to assign a macro to run everyday at, lets say , 8:00am. Is it possible that I do not open the workbook and yet the macro is automatically run and save to filename_Date?
  5. M

    Fixing time range

    Hi all, first post here so pls pardon me if my question is not clear. I'm in production planning and i would like to see the output of the production from , lets say 8.05am of 10th Aug to 8.05am of 11st Aug. The data is like this where the data i get should stop at 8.05am which means it...
Back
Top