• 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

    Copy filtered range and paste in another sheet (exclude header)

    excellent. Thank you
  2. M

    Copy filtered range and paste in another sheet (exclude header)

    Is there a way to copy filtered range and paste it in another sheet lastused row everytime without its header ? I have a dataTable already filtered by some criteria (sheet=Home). Header is already available in the destination sheet "Data". Copy filtered range and find lastUsed row in sheet...
  3. M

    Is there a way to add "CommandButtons" next to each cell ?

    yep, I got it working
  4. M

    Push a dataRange from active workbook into a closed workbook

    Is there a way to filter columnA and copy data into a file.xlsx located in a closed folder ? Select Team Game Score Yes A Cricket 98 Yes D Cricket 92 Yes C Cricket 91 Yes W Football 88 Yes J Football 100 Activeworkbook path: C:\Users\excelUser\Documents\dataFile.xlsm To...
  5. M

    Is there a way to add "CommandButtons" next to each cell ?

    @jolivanes thanks for trying...
  6. M

    Is there a way to add "CommandButtons" next to each cell ?

    Imagine, I've a data table that I send across to my customer for them to select/add specific rows that they feel are ready to be analysed further. Is there a way, I can provide them with command buttons so they can click add and revert ? Select Team Grade Score A A 95 B C 78...
  7. M

    How to replicate data in column B with column A [code snippet required]

    Thank you very much
  8. M

    How to replicate data in column B with column A [code snippet required]

    With the sample file attached, there are 2 columns. Column A has ID that is unique. Column B has comma separate values. Wherever there are multiple values in columnB, ID in columnA has to be replicated to take values from columnB and create multiple rows accordingly. ID Names ID Names...
  9. M

    Get twitter @mentions data in excel

    Hello, do you know how to get count or data around twitter mentions into excel ? If there is a tweet with @Deeplearning, then I should be able to get the count. Any ideas ?
  10. M

    VBA ppt pastemultiple slides | center object or fit

    Hello, I have a macro that captures certain ranges and paste them into the PPT (open/active PPT). But these images in PPT are not centered properly. Please can someone help to fix this in VBA code. Please see the sample file attached.
  11. M

    Filter and show rows

    Thank you @bosco_yip I can utilize this.
  12. M

    Filter and show rows

    @vletm , Yes but the main intention is to sort them down by date & track the events. When they called call center & after that what follows in a sequential order. your thoughts ?
  13. M

    Filter and show rows

    @vletm : thanks for responding. No, for CAN, total number of rows may vary depends on customer. This data is for visualization & storytelling purposes. Also, I need to sort data by date latest. Any thoughts ?
  14. M

    Filter and show rows

    Hello, I have a requirement is filter a column & extract/show activities from other columns in a sequence. Is there a way we can do this with excel formula ? Appreciate your help. Please see the same file attached. BR, K
  15. M

    Formula to pull data from various sheets

    thanks @bosco_yip
  16. M

    Extract data from a website

    @Hui
  17. M

    Formula to pull data from various sheets

    Hello, I have a requirement to pull data from various sheets. Say, I have a dropdown for list of variables, data for each variable resides in a particular sheet. Is there a formula to index match, or lookup data from pertaining sheet as per the value selected ? See sample file attached. Best...
  18. M

    Extract data from a website

    Hello Experts & Excel Enthusiasts, I have a requirement to import/pull data from the website provided below. I may require macro code to extract data for a particular region, say The United States. Website : https://tradingeconomics.com/united-states/indicators And there is an another...
  19. M

    Two dates and a formula

    Thanks Narayanan
  20. M

    Two dates and a formula

    Hello, I have an activity where I need to list dates between 2 dates. But it varries with the period we select. Say, for D1, 01Jan to 28Jan but for D2, 29Jan to 2nd Apr and vice verse. Is there a formula to list pertaining dates ? Much appreciated. See sample file attached... Thanks, Kar
  21. M

    Is it possible to show a pic in userform ?

    Ninjas/experts: I am currently performing an activity where I need to show a picture that is saved in another sheet, same workbook. Is there a way to show that pic in an userform ? Kindly help with a code snippet. Much appreciated. Best Regards, Kar
  22. M

    Embed excel sheets in outlook body

    Hello, Is there a way to embed excel sheets within the body of the email ? Kindly provide your views. What am I trying to do: I have a requirement to project 4 dimension data in an email. For example: there are categories, sub categories, time, KPIs and related metrics. The more we club data...
  23. M

    sum between two times with a particular date | formula required

    excellent. Thank you @bosco_yip
  24. M

    sum between two times with a particular date | formula required

    A small twist here. Can we able to compose an excel formula to calculate data for an hour, if 9 AM is mentioned, the formula should capture data between 8AM and 9AM. If 10AM is in cell, it should calculate data between 9AM and 10AM
  25. M

    sum between two times with a particular date | formula required

    Hello, I have a table from where I need to pull or sum data that occurs between two times. Kindly refer to the sample file attached & provide a formula. Thanks, Kar
Back
Top