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. pecoflyer replied to the thread Merge multiple Sheets into one.

    Why not use the add-in which I provided the link for? No code needed

    Nov 17, 2018 at 4:14 PM
  2. kaarthikz posted a new thread.

    Command button to open file explorer in Macro and store path, run the VBA

    Hi All, Below is the code for Macro which opens all the excel files in the given folder and pastes the data in the Macro enabled sheet...

    Forum: VBA Macros

    Nov 17, 2018 at 2:13 PM
  3. Deepak replied to the thread Merge multiple Sheets into one.

    Will you pls share a sample file and expected output so that we may suggest a alternate method if available...

    Nov 17, 2018 at 12:47 PM
  4. Abrienne replied to the thread Merge multiple Sheets into one.

    Is there any other way other then code

    Nov 17, 2018 at 12:45 PM
  5. Abrienne liked Logit's post in the thread Merge multiple Sheets into one.

    Private Sub CommandButton1_Click() Dim WS1, WScur As Worksheet Set WS1 = Sheets("YTD16") For i = 2 To ActiveWorkbook.Worksheets.Count...

    Nov 17, 2018 at 12:44 PM
  6. Peter Bartholomew replied to the thread Relative referencing is wrong.

    I need to reference ID generated in the first step in the second Chihiro I am not fully sure I understand the setup but then, I rarely...

    Nov 17, 2018 at 12:10 PM
  7. Khalid NGO liked Peter Bartholomew's post in the thread Excel pet peeves.

    My peeves are not going to be fixed; it is simply not possible to turn back time. For me, misnamed functions grate. INDEX - this function...

    Nov 17, 2018 at 6:57 AM
  8. AAP replied to the thread Structuring Data (Visualising).

    Your solution worked even more quickly. Genius!!! Many many thanks

    Nov 17, 2018 at 6:54 AM
  9. AAP liked bosco_yip's post in the thread Structuring Data (Visualising).

    Or another formula option but without helper In H7, copied across and down :...

    Nov 17, 2018 at 6:53 AM
  10. AAP replied to the thread Structuring Data (Visualising).

    Works Perfectly. Thanks a lot.

    Nov 17, 2018 at 6:53 AM
  11. AAP liked chirayu's post in the thread Structuring Data (Visualising).

    see attached

    Nov 17, 2018 at 6:53 AM
  12. Hui replied to the thread Testing for "Blank" Cells with VBA.

    If len(NumOne) = 0 OR Len(NumTwo) = 0 Then you also might be better to pass the NumOne and Numtwo in as Ranges rather than as Doubles

    Nov 17, 2018 at 6:45 AM
  13. Khalid NGO replied to the thread Testing for "Blank" Cells with VBA.

    Hi Erik, Have you tried IsEmpty in vba? Regards,

    Nov 17, 2018 at 6:41 AM
  14. Khalid NGO liked GraH - Guido's post in the thread Congratulations @bosco_yip for your 2,000 + helps ! :).

    Even more impressive, over 2.5K likes. Congrats @bosco_yip.

    Nov 17, 2018 at 6:27 AM
Loading...