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

    Show Dashboard, Graph from 3 different worksheet

    @Chihiro I merged all worksheet into one to do pivot and graph. Now, i have 3 different questions : 1) How to find text value name from cell ranging E5 to AZ5 [ This should be for all rows ] Example : If Row 2 has value Verizon from Column E5 to AZ5 how can we find what value [ text "...
  2. MaunishP

    Show Dashboard, Graph from 3 different worksheet

    @Chihiro : Thank you for your response. This format is suggested by team, hence cannot change format. If you can provide some suggestion regarding this format. Basically this sheet we fill up to book our training room and conduct training. From this current format data can we combine data...
  3. MaunishP

    Show Dashboard, Graph from 3 different worksheet

    Hi Team, Would like to see dashboard, report and graph from 3 different worksheet information in one worksheet. I have 3 different files showing day on day information of work done in 24 hours. Would like to see holistically data on final sheet like : Number of training conducted week wise...
  4. MaunishP

    Excel Dashboard - To find Rooms available along with Trainers

    Thankyou @vletm Show your file and thoughts came nearby what they was as expectation. Once i received update for final confirmation will again thank you. Regards,Maunish Patel
  5. MaunishP

    Excel Dashboard - To find Rooms available along with Trainers

    Extremely sorry for uploading incorrect file :-( I need to get this file for approval by 01/25/19 max by 01/31/19 Also find attached file which we were using it earlier, however still i am not able to find training rooms availability, trainers, date and timing. Regards, Maunish Patel
  6. MaunishP

    Excel Dashboard - To find Rooms available along with Trainers

    Thanks for your reply @vletm Below given are responses to each questions : ... when something is free? ... there would be a lot of frees ... a lot! - We want to track Training Room, Trainers, Date and Timings when its free / available so that front desk team can book it accordingly. As we...
  7. MaunishP

    Excel Dashboard - To find Rooms available along with Trainers

    Hi Team, I would like to build a dashboard to know which all training room are occupied from which date to which date, along with time in all mentioned location after inserting data manually. These training rooms should be occupied 24 * 7. Would also like to know which trainer has no projects...
  8. MaunishP

    If & And formula with multiple condition

    Thanks a ton. This is what i was looking for
  9. MaunishP

    If & And formula with multiple condition

    Hi, Just modified condition criteria Bucket <= 30 > 30 - <=60 > 60 - < =90 > 90 - < =120 > 120 - <= 180 > 180 Also I am looking for In days formula. Regards, Maunish Patel
  10. MaunishP

    If & And formula with multiple condition

    HI Team, I am looking for formula to with multiple condition to find out real bucket. Also i want to if end date is there then it should calculate end date minus hire date, IF termination date is not there then it should calculate today date minus hire date./ I have attached excel sheet...
  11. MaunishP

    Moving Multiple Files from One Folder to Another (Create Folder & Save Files)

    Dear Team, I am looking for macro which will move multiple files from one folder to another. Below given is detailed request what i am looking for : 1) I need first macro to create folder name based from column A then .... 2) Then move files which are aligned with respected batch code (from...
  12. MaunishP

    VBA Macro required - Copy data from another workbook and paste in new cell and delete it then

    Hi Marc, Yes i need to only copy 4 columns from sheet 5 and paste in DataRequiredHere sheet
  13. MaunishP

    VBA Macro required - Copy data from another workbook and paste in new cell and delete it then

    Hi Team, I would require a macro to copy data from one worksheet from ROW 1 , only copy 4 columns and paste in another worksheet and then paste data below new row. It should be a continous process. I have attached both worksheet. DataRequiredHere Worksheet should have data pasted below in...
  14. MaunishP

    Adding Weight age to Attendance if Status " YES "

    Hi Sir, I would require both because there might be training schedule for 8, 6 or 4 hours. Also excel file which you have provided in column J - Row 2 : 80% is required to be eligible to final exam. However what i require is if any student submits his project and trainer marks YES in column J...
  15. MaunishP

    Adding Weight age to Attendance if Status " YES "

    Dear Team, I got new project into training, however we need to add project based learning. I have change this format multiple times based on client needs. Now below given need has generated very differently where my brains got stopped. Please help out using formulaes : There are total 2 sets...
  16. MaunishP

    Leave Balance to carry forwarded every month - Attendance Sheet

    Hi Team, I would require a formula / dashboard where August we start our new year, where each employee is credited 2 leaves every month, now if any employee takes any leave in first month as per example Mr.A has taken 3 leaves in August now his leave balance should come -1, however rest...
  17. MaunishP

    How to find difference value from 2 different worksheet

    Hi Team, I have solved it by searching few articles and using formula of Vlookup Regards, Maunish Patel
  18. MaunishP

    How to find difference value from 2 different worksheet

    Hi Team, I would like to find difference value between 2 different sheet for specific users only. Please find attached excel sheet, where there are 3 worksheets - 1> Daily Ftype Report 2> Monday Ftype Report & 3> Difference Count I would like to have difference value from worksheet 1 & 2 in...
  19. MaunishP

    Macro to Copy data for specific date from different worksheet but from same workbook

    Hi Deepak, Any updates on this topic> Regards, MP
  20. MaunishP

    Macro to Copy data for specific date from different worksheet but from same workbook

    Hi Deepak, Could you please intervene and help for above provided soultion in detail.
  21. MaunishP

    How to combine these 2 different VBA codes

    Hi all, Can some Ninja, members or expertize intervene into this query. Regards, MP
  22. MaunishP

    How to combine these 2 different VBA codes

    Hi Team, Could you please provide a solution to club these 2 VBA codes and ensuring that workbook which is been saved in specific path with specfic format " Your Name_Ftype_TodayDate " Here goes Code 1, which allows me to split worksheets from column A, but i will like to refer to data in...
  23. MaunishP

    Thinking out of the box - Dashboard Prototype

    Hi All, Can some of the best brains in this forums throw some light on above given query. Thanks in advance Regards, MP
  24. MaunishP

    Macro to Copy data for specific date from different worksheet but from same workbook

    Hi Deepak, I am not much good into VBA, however i am learning from my mistakes, could you please add to above sheet and so me how does it work. Also will data be pasted for today date there? with the same macro? Regards, Maunish Patel
Back
Top