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

    Macro that will produce 2 output csv file based on source

    help, and ask me if any doubts... badly needed this, thanks in advance..
  2. R

    Macro that will produce 2 output csv file based on source

    Badly needed help for this, Im willing to donate too...
  3. R

    Macro that will produce 2 output csv file based on source

    Hi, I had a situation; I have one main csv file namely - "Downloaded_Data" which basically the master or the primary source file. Then there are multiple csv files that file name begins with s - on this sample I given one file only namely - "S12345.csv" (but it might come in multiple files...
  4. R

    If there is a number in cell put % symbol in that number

    HI Wow this is superb.. Thank You So Much ^_^
  5. R

    If there is a number in cell put % symbol in that number

    Hello, Thank You so much, Your second macro is working but it's only in active cell.. is it possible that when i select the entire column the macro will run instead of one by one cell? It's perfect...
  6. R

    If there is a number in cell put % symbol in that number

    Please see attached output file for the same
  7. R

    If there is a number in cell put % symbol in that number

    Hi, Wow Thank You Almost done but if data is like this 80 ABCDEFG 15 HIJKL 5 MNOP LININ: 100 WXYZ RESULT IS 80% ABCDEFG 15% HIJKL 5 MNOP LININ: 100 WXYZ% notice that the % is not coming in middle and in last number also, no % symbol, instead it went on the last portion....
  8. R

    If there is a number in cell put % symbol in that number

    yes expected result is just all number will have a percentage symbol at the end
  9. R

    If there is a number in cell put % symbol in that number

    Hi, I have a cell with alphanumeric character the problem is, i want to put percentage symbol in any number on that cell.. Here is a sample data in cell.. ABC 95 CDF 100 KLM 9 CD 124 AGH 29 QLK 12 That sample above is a two rows in one column on that column I want to put a % symbol in the...
  10. R

    Help For Macro to Create Pop up for Certain Condition

    I tried to run in 300K lines and still showing overflow when tried to debug it goes on this line j = j + 1 output came but some lines did not total it repeating as other line not total..
  11. R

    Help For Macro to Create Pop up for Certain Condition

    I tried to reduce the nos of rows from 1M into just 1K but the macro just keep on running for long time.. Can someone help me with this, badly needed...
  12. R

    Help For Macro to Create Pop up for Certain Condition

    Unfortunately This macro is not working when dealing huge data..
  13. R

    Help For Macro to Create Pop up for Certain Condition

    Hi Belleke, Sorry to bother you again, Actually today I run your Macro but the things is I run it in a data with 1048574 number of rows hence i received a run time error '6' overflow and when i click debug button it goes here count = Application.WorksheetFunction.CountIf(Sheets("STORE COUNT...
  14. R

    Help For Macro to Create Pop up for Certain Condition

    Hi, Woaahhhh perfect.. It saves my day... Great Macro.... :) THANK YOU SO MUCH... MANY MANY THANKS... :-*
  15. R

    Help For Macro to Create Pop up for Certain Condition

    Hi, I tried it, but now nothing happened, pop up not came :(
  16. R

    Help For Macro to Create Pop up for Certain Condition

    Basically, there should be a breakdown of how many are equal and less than 0 in each and everything in column P, as that is the most important, then finally in the button the total of it.. Note: That its should show the pivoted total of each category, as I tried to add another line, it;s...
  17. R

    Help For Macro to Create Pop up for Certain Condition

    HI, That is what exactly what im looking for, but it should give the breakdown also of each, not only total.. In user Form it should be, Category 16 SH That is less than or Equal to 0 ANDROMEDA 1 ASTEROID 1 MARS 1 OMEGA 1 OMNICRON 1 RIEGEL 1 Grand Total 6
  18. R

    Help For Macro to Create Pop up for Certain Condition

    Hi, I need a macro that when button press will create either a Pop UP (Msg Box) or a New Excel Sheet base on a given condition of a certain column like counting the number of SH with less than or equal to Zero then it will pop up (msg box) or create a new excel that will give those categories...
  19. R

    Macro for Creating New Sheet as per condition

    Yes I do have. Its very fine now, but again need help, I sent a msg to your mail privately. Thank You so much for your macro, such a big help. But one more help, I need a Macro based on your output macro that when a macro button click, it will pop up a msg box and will show the total of all S...
  20. R

    Macro for Creating New Sheet as per condition

    HI p45cal, It's more than enough, thank you so much for your great help, I done this in Power Query of excel but there is a limitation also while doing tranSpose as it is a huge data, but no problem, i will just limit some columns in the back end query to reduce data number rows and your macro...
  21. R

    Macro for Creating New Sheet as per condition

    Hi, It is possible to put the rearrange item in new sheet rather than next to clicking button? Thank You so much...
  22. R

    Macro for Creating New Sheet as per condition

    HI Thank You so much... for such a great help....
  23. R

    Macro for Creating New Sheet as per condition

    Hi All, I have an excel sheet in sheet 1 is my source file, I want a macro that will create 2 sheet base on the given condition as per sheet 1 as source: Condition 1 ): It will create a sheet 2 and do the sum and pivot for Total Zero sold, destination wise. Condition 2: It will create a sheet...
Back
Top