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

    Excel Cannot hide row

    Hi, Can anyone help to recommend as i have a problem regarding hiding row in excel. Between row 374 to 439 (I divided into 2 parts from 374 to 406, and from row 407 to 439). Between these 2 parts, i can only hide 1 part. Ex: If i hide part 1 (row 374 - 406) first, i cannot hide the 2nd part...
  2. K

    Is the data publish from power BI desktop safe?

    Hi, I am currently develop dashboard in power BI desktop and wanted to publish it into web. However, i am not sure if my data can be viewed by anyone or not as i was told that after i published into my workspace, still that data become public data which can be viewed/accessed by anyone. Can...
  3. K

    Excel cannot add 2 combo boxes

    Hi, I have one question if excel can add 2 combo boxes or not. I have tried to create searchable drop down list. To do that, it require to make some more formula and create some name range plus VBA code just to show all drop down when we type the word. It works perfectly fine when i create 1st...
  4. K

    Calculate productivity and make Chart

    Hi, I want to calculate productivity and make a chart in power BI. I am very basic in power BI. Thus, i cannot calculate across table. Seems like my requirement need to sum up all sales and number of staff first before calculate productivity. Please find attached file for more detail. I would...
  5. K

    Why UI on my power query is different from other

    Thanks for your response. Anyway, when going on YouTube, i also see some people using office 2016, but the feature is also different from me. Is there any different version 2016? Thanks, Chanthan
  6. K

    Why UI on my power query is different from other

    Hi, My excel 2016 have power query, but its option seems very limited. There are a lot of tools it doesn't have. Ex: In ribbon add column, i don't have Extract, or no column from example... Attached is my screen. Can you please advise what should i do to have all available option? Thanks,
  7. K

    Double Loop

    Thanks very much for your kind support. I'll check to understand more and will reach you again if any concern.
  8. K

    Double Loop

    Hello, I have 2 sheets. One is all data and another one is Daily Target. Everyday, i need to generate 5 sample record per office to store in Daily Target. After that, i need to mark those record as Picked in sheet All Data. Next day, i need to generate another 5 records which its status is not...
  9. K

    Copy Visible cell only

    Sorry, i forget using it.
  10. K

    Copy Visible cell only

    Hi, I have some issue regarding copy visible cell only. Can anyone help please? Below is my full code. KIM Chanthan You have asked many time to >>> use code - tags <<< Sub Con_Each_File_to_Each_Tab() Dim FolderPath As String Dim Filename As String Dim Sheet As Worksheet Set Master =...
  11. K

    Copy sheet to another workbook

    Hi Jolivanes, Thanks for response. Along with above issue. i have just found another challenge and here is the whole script that i have just raised. https://chandoo.org/forum/threads/copy-data-and-paste-in-new-sheet-in-new-workbook.45050/ Much appreciate if you can help. * Sheet Product is at...
  12. K

    Copy data and paste in new sheet in new workbook

    Hi, I want to copy data from one sheet and want to paste it in new sheet of another workbook (Master file). Below code work perfectly as expected, but because of the link, all the data become #VALUE! when i reopen it or share master file to other people. So could anyone tell me how to solve...
  13. K

    Copy sheet to another workbook

    Hi, Anyone can help with below issue? I try with this code and it works fine. Just some user rename my sheet name and it cause error. Worksheets("Product").Copy After:=ThisWorkbook.Sheets(D) To solve with different name, i try with the sheet number in stead, but it doesn't work...
  14. K

    Loop each workbook and update value base on current Workbook value

    I have just found they way to loop columns. And i apply it with my real working. I found it works perfectly with below code. ---------- >>> use code - tags <<< Sub EmbedDATA() Set ws = Workbooks("Value File.xlsm").Worksheets(1) 'Open Directory and Listing all File directory =...
  15. K

    Loop each workbook and update value base on current Workbook value

    Hi, I have one issue to loop each workbook and update the data every month. I have tried to write one code, but it could only update 1 cell by single formula. So there are 4 cells (For one month), i need to write 4 formula. So going along with this kind of formula, i might need to create 4 * 12...
  16. K

    Workload change every 3 month base on number of recruit

    Thanks for your great help. It solved my issue.
  17. K

    Workload change every 3 month base on number of recruit

    It works magically as expected. Thanks
  18. K

    Workload change every 3 month base on number of recruit

    Hi, I want to designed workload for my staff. That workload will be change every 3 month starting from recruit date. We just put number of recruitment in any month and workload will automatically calculate and change every 3 month. Please refer to attached file for more detail. Thanks,
  19. K

    Hyperlink to specific cell across sheet

    Thanks Chihiro for your help. It works perfectly as expected
  20. K

    Hyperlink to specific cell across sheet

    Hi, Is there any can help if i want to make hyperlink to specific cell across sheet. There are so many places i need to hyperlink and i will take time without formular. Please find attached file for more detail. Thanks,
  21. K

    Countif with < or > sign

    Thanks for clear explanation.....
  22. K

    Countif with < or > sign

    Thanks a lot for help
  23. K

    Countif with < or > sign

    Hi, Anyone can help? I face one issue regarding countif or sumif with < or > sign. I suppose it is a string, but i don't know why my formula not work. Please refer to below screen for detail.
  24. K

    Display week number starting from week 1 by specific month

    Thanks Chihiro. It works perfectly as expected.
  25. K

    Display week number starting from week 1 by specific month

    Hi, Anyone can help to solve my issue like below question: Ex: In Aug-2020, there are 6 weeks, So I want it to display 6 week by starting from week 1 to week 6 in each columns. Thanks, Chanthan
Back
Top