The template of Quality Check list has been designed to use for quality team.It can be use for other purposes also. Here we have taken the drop-down as Pass/Fail. You can use it as Yes/No, Pending/Completed ect. This template can we used for multiple purposes. It automatically change the text with Icons on the base of conditional formatting. There is no VBA code has been used. Pass/Fail drop down in
In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor >
In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime [caption id="attachment_7149" align="aligncenter" width="459"] Add Reference[/caption] We
This calendar template is fully dynamic. If you will change the month or year in the drop down calendar will be change automatically. To creating the month and year drop down Form Control combo box has been used. It has been created purely in Excel with the help of formulas and conditional formatting. No VBA has been used. [caption id="attachment_2434" align="aligncenter" width="641"] Dynamic Calendar in Excel[/caption] Click to download Dynamic
This template has been designed for consolidating the data from multiple excel file into a single file. This is very time saving template and can make your work very easy. There are two worksheet available in template file, one is "Logs" and second is "Consolidated_Data". Logs worksheet: In this worksheet on Column A you will see the File Names from which you have consolidated the data and on column B
This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not be changed manually. [caption id="attachment_2413" align="aligncenter" width="546"] Data Entry Form Output[/caption] There are three buttons available in this worksheet. 1.Add New Record By using this button a record can be added on the worksheet. Below given form will be opened
Bow and Arrow Game has been designed in Excel with help of VBA. Few images have been taken form pixabay.com. In this game you have to shoot the apple which is dropping from the tree with the help of 10 arrows. There is a speed drop down available with the Low, Medium and High option. You can the apple dropping and arrow speed by changing this drop down. [caption id="attachment_2401"
Attendance tracker or Attendance sheet is essential to any organization. This Attendance tracker is designed for keep one month data. In this attendance tracker, Employee Name, Supervisor, Present count, Absent Count, Leave Count, unplanned%, Planned % and dates for particular month field are available. [caption id="attachment_2395" align="aligncenter" width="640"] Attendance Tracker in Excel[/caption] Emp Name and Supervisor name to be entered manually. Present Count, Absent Count, Leave Count, unplanned% and Planned
Age Calculator template tells your exact age till today. You need to enter your date of birth in the DOB box. It will given you your age like "You are 26 Years, 3 Months and 4 days old." [caption id="attachment_2384" align="aligncenter" width="982"] Age Calculator in Excel[/caption] To create the Age calculator Datedif formula has been used. on the sheet1 you will find the calculation that how to calculate the age in excel
Absenteeism is very useful for any process. In this absenteeism report template there are 6 worksheets available Index: Index worksheet is used to navigate the other worksheet-like summary, month wise, date wise and supervisor wise. [caption id="attachment_2377" align="aligncenter" width="449"] Index Worksheet[/caption] Summary: In this worksheet a chart of month on month comparison for planned% Vs Unplanned% is available. Overall NCNS (No call No show) count , Planned % and Unplanned%
