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...
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...
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 Team,
I am clubbing my previous thread here, due to Thread name i have posted incorrect, hence there were no views towards it.
http://chandoo.org/forum/threads/send-mail-from-excel-to-outlook.22962/
Here goes my query :
I have an excel file each month with three different worksheet. I...
Hi Team,
I was going through many articles in this forum to check VBA code to send mail from Excel to Outlook directly. I got a great link http://www.rondebruin.nl/win/s1/outlook/bmail3.htm, however this still doesnt full fill my requirement.
This is a snapshot what my requirement are...
Hi Team,
I am creating a dashboard for my helicopter view, I was not able to think best what can be done from this pivot table and Dashboard output. I was looking for a Overview sheet which will show me all information in single go such as :
If I select Name it should show which team he /...
Hi Team,
I want to count cells conditional formatting highlighted cells from
on another worksheet here ...
Please find attached workbook.
Regards,
Maunish Patel
Hi Team,
Could you please check below given error while running macro >
I tried to replace VBA code, however some glitch happed which turned this error. How to get rid of it. Please find attached file also along with VBA code
I havent pasted VBA code here due to character limitations...
Hi Team,
Is there a way for a I will insert data in sheet and run VBA code to umerge horizontal data then transpose it to vertical data and refresh pivot.
Once data is collected then I would also like to have a Macro for RESET which will reset my VBA code.
Merged Data Looks Like this ...
Hi Team,
Initally data which i use to get was in single worksheet, where i had created marco which will umerge all cell names, transpose to different worksheet from horizontal to vertical. But now, as new work increased I have now only 1 workbook with 12 worksheet and different team members...
Hi Team,
Have a data which looks very simple while reading on excel, however cant think much more to put ideas on out on chart or some out of the box data visualization.
Would like to have a chart which shows me trend, forecast variance, shows good week bad week, and much more statistical...
Hi Team,
I already have a code which is able to consolidate multiple workbooks into one sheet, however it only copies data from 1st worksheet, but i want to copy all data from worksheet 2.
Naming structure for each workbooks for worksheet 2 will not be same.
Please help where i can...
Hi Team,
I have couple of websites which i need to scrub data from html format to excel format. Below given are steps which i perform daily :
1) Open Website : http://registers.maryland.gov/main/search1.html
2) Select County from the drop down
3) Select date range for last 3 months
4) Search...
Hi Team,
I have 2 worksheet sheet, TrackTime & Listing. In TrackTime if any team member selects any listing from Column E, he should only get option which are categories in Worksheet Listing in from Column E & F. How to use Offset formula.
I have attached sheet.
Regards,
Maunish Patel
Hi Team,
I have a VBA code which allows me to double click and insert timestamp in Column K & L, however every time I insert data in K1&L1, it should get locked and no one should be able to edit data. However if i move to next row then I can enter data in K2&L2 and follow same process Lock -->...
Hi Team,
Whenever i use Ctrl + Shift + :, it is showing HH:MM format only, i want to record seconds also in it. Please provide me a solution to attached file
Regards,
Maunish Patel
Hi team,
Please help me visualizing this data in to graphs, every time i provide this data to my senior in table format. This time i want to do something different.
Could you guide me how to visualize this data ?
Regards,
Maunish Patel
Dear Team,
I am trying to create macro where I want my team member to send report bi-hourly basis through Microsoft WebOutlook App using Excel [Small button which says "Send Mail" and same I need to copy paste data into excel against thier name.
It is easy to capture data during 5-6 team...
Hi Team,
How to use if formula for data which gives me door access database. I will require every team members start time and end time from door access database. Searching it manually is okay, however searching it for 150+ members is diffcult. I have attached sheet which contains 2 sheets...