1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

  1. PCosta87 attached a file to the thread Pulling List of Data, based off of Drop Down Selection.

    Hi, Attached... A combination of INDEX/SMALL/IF in array form should do it. Copy down as necessary. Hope this helps.

    Mar 24, 2017 at 12:06 PM
  2. bosco_yip replied to the thread How to find number in a string and extract number to new column.

    Or, In B1, copy down : =0+MID(A1,4,FIND("_",A1)-4) Regards

    Mar 24, 2017 at 12:04 PM
  3. Afox10 posted a new thread.

    Pulling List of Data, based off of Drop Down Selection

    Excel Community, Please see attached file for example. I am wondering if there is a formula to create a list of "upcoming" machines...

    Forum: Ask an Excel Question

    Mar 24, 2017 at 11:57 AM
  4. vletm attached a file to the thread Using VBA scripts to Combine multiple workbooks.

    @ie6799u Sample = not fully tested ...

    Mar 24, 2017 at 11:53 AM
  5. Charter replied to the thread Advice on simple gap filling Macro?.

    Hi Marc, Wow, that was quick and works very nicely - thank you.... now I just need to understand how it works :-) Cheers.

    Mar 24, 2017 at 11:49 AM
  6. Charter liked Marc L's post in the thread Advice on simple gap filling Macro?.

    Hi ! At beginner level using Excel basics : Sub Demo1() Dim Rg As Range Application.ScreenUpdating = False With...

    Mar 24, 2017 at 11:47 AM
  7. ranjitha replied to the thread Macro to find diffrence b/w two sheets and copying the diffrence data into another sheet from oldfil.

    yes this is working but one misunderstand, changing rows should happen in sheet 2 not in sheet 5, what evere thr in sheet5 should be copied...

    Mar 24, 2017 at 11:44 AM
  8. Balajisx replied to the thread Need Macro to Split First Name Last Name Middle Name Surname.

    Thank you. There is an other issue. For eg Name :Kevin J. Corcoran First Name should be Kevin J last Name should be Corcoran How this...

    Mar 24, 2017 at 11:33 AM
  9. ranjitha attached a file to the thread Macro to find diffrence b/w two sheets and copying the diffrence data into another sheet from oldfil.

    hi, i tried you code....let me send you my cope of excel file.....everything is fine apart from sheet2 rows getting replaced with sheet 5...

    Mar 24, 2017 at 11:30 AM
  10. jk51 replied to the thread How to find number in a string and extract number to new column.

    Thanks Chirayu. It's all working. Excellent. Bw Mr Singh

    Mar 24, 2017 at 11:27 AM
  11. jk51 liked chirayu's post in the thread How to find number in a string and extract number to new column.

    Sample file attached

    Mar 24, 2017 at 11:26 AM
  12. chirayu replied to the thread I want to add file Names in Each Sheet.

    You need an extra variable to store the workbook name after you open it. So the bit in your macro where you've got the below Set WKB =...

    Mar 24, 2017 at 11:17 AM
  13. ranjitha replied to the thread Macro to find diffrence b/w two sheets and copying the diffrence data into another sheet from oldfil.

    ok thank you...no one need to help me...i am feeling sad...its ok let me try my own code ... i think only i understand my requirements...

    Mar 24, 2017 at 11:17 AM
  14. chirayu attached a file to the thread How to find number in a string and extract number to new column.

    Sample file attached

    Mar 24, 2017 at 11:10 AM
Loading...