@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 "...
@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...
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...
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
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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