Home
Videos uploaded by user “Dinesh Kumar Takyar”
Auto run vba project When an Excel Workbook is opened
 
04:15
How to auto-run a VBA project when an Excel workbook is opened. A simple but profound question whose answer is not easily available on the internet or Google as experienced by Alex. The answer is simple - first create your macro, then add a single line of VBA code to 'ThisWorkbook' in the VBA editor that accesses the macro when the workbook is opened! You can view more details here: http://familycomputerclub.com/auto-run-vba-project-ms-excel.html
Views: 52553 Dinesh Kumar Takyar
How to capture data from userforms into Excel worksheet
 
05:09
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can capture data from userforms and place it into an Excel worksheet. The process involves creating a userform with the appropriate labels and text boxes and a command button. The command button has the code to transfer the data from the user form onto the worksheet. First we identify the empty row in the Excel worksheet and then the data is transferred cell by cell from the text boxes. The complete process is easy when you think through it and code it step by step. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 221824 Dinesh Kumar Takyar
Forecast Function in MS Excel
 
04:39
The forecast function in MS Excel can be used to forecast sales, consumer trends and even weight loss! For more details: http://www.familycomputerclub.com/excel/forecast-function-in-excel.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 495473 Dinesh Kumar Takyar
How to create notifications or reminders in Excel
 
09:11
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can create reminders or notifications in MS Excel using 3 methods quickly and easily: 1. Use the IF function to display a message 2. Use conditional formatting 3. Use Excel VBA All the 3 methods are described in the training video. You can view more details here: http://www.familycomputerclub.com/how-to-create-reminders-notifications-in-excel-automatically.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 887999 Dinesh Kumar Takyar
Using ListBox on UserForm in Excel
 
04:19
How to insert a listbox on a userform and use it in combination with a named range and a coded command button to transfer data from the listbox to an Excel worksheet. You can also watch the last video on UserForms to firm up your understanding. For more details you can visit the webpage: http://www.familycomputerclub.com/using-listbox-on-userform-ms-excel.html For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 116261 Dinesh Kumar Takyar
Calculating time difference in MS Excel
 
05:09
Time difference calculations can be important and useful in a variety of situations like when you wish to calculate the number of hours worked or when you do an experiment where you have the start time of a chemical or biological reaction and the end time. Sam has a similar problem. Calculating time differences in Excel are easy and we describe two methods. The first method is the standard formatting route. The second method does a kind of validation where we check whether the user has entered both the start and end times. This helps to avoid useless calculations in time differences. For more info you can visit: http://www.familycomputerclub.com/calculating-time-difference-in-ms-excel.html
Views: 78992 Dinesh Kumar Takyar
create charts using excel vba
 
05:55
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. For details you can visit our website: http://www.familycomputerclub.com/create-charts-using-excel-vba.html We can create charts quickly and easily using Excel VBA.
Views: 51329 Dinesh Kumar Takyar
How to Update PivotTable When Source Data in Excel Worksheet Changes Using VBA
 
05:12
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com Today we learn how to update the PivotTable when the source data in the Excel worksheet changes using VBA.
Views: 62728 Dinesh Kumar Takyar
Import data from Word to Excel
 
03:49
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com Most people create documnets in MS-Word jus like Carmen who send this query: 'I have more than 3000 part-numbers and their descriptions in a MS-Word document. I would like to get the data into MS-Excel because I know I could save a lot of time when I wish to extract specific data for my boss. Also when I enter the same data manually into Excel I'm unable to separate the part-number from the description. I am sending some examples of the records: 003-1620-3540 XNB-5760 MULTIPLE 001-1640-3560 JXU-4860 IR SENSOR UNIT, EVS 002-1660-3580 JXU-5860 UV SENSOR UNIT, EVS Please help ASAP. Thanks.' You can first select the required data and save it as a text file right inside MS-Word or paste it into Notepad. Now you can import this data easily into Excel using the import wizard step by step as shown. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 380290 Dinesh Kumar Takyar
How to enter only weekdays in an excel worksheet
 
01:51
Why waste time entering dates manually in an Excel workheet when you can use the fill series feature to fill dates of weekdays only and avoid the weekend dates
Views: 9951 Dinesh Kumar Takyar
Allow data entry only in specific worksheet cells in Excel
 
02:49
To improve speed of data entry and avoid errors you can allow users to enter data only in specific Excel worksheet cells like when filling out an invoice or payroll form.
Views: 27013 Dinesh Kumar Takyar
Highlighting Excel cells while entering data
 
03:30
You can easily highlight MS Excel worksheet cells while entering data using Excel VBA. For many people this can be a useful tool to avoid incorrect entries. For color codes you can view this website: http://dmcritchie.mvps.org/excel/colors.htm For many more interesting videos you can visit: http://www.familycomputerclub.com For some more details on this specific video please visit: http://www.familycomputerclub.com/highlight-excel-cells.html If you wish you can subscribe to my channel and be notified whenever a new video is uploaded.
Views: 14000 Dinesh Kumar Takyar
Dynamic named ranges and offset function
 
11:09
Understanding dynamic named ranges requires a good understanding of the offset function in MS Excel.
Views: 43474 Dinesh Kumar Takyar
Data tables and sensitivity analysis Excel
 
04:27
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.comData tables provide an elegant way to perform single and two-way sensitivity analysis on your Excel worksheet data. What is a single variable sensitivity analysis? It is the process by which you find out how one value changes based on a change in another value. You may wish to know how your monthly payments change with change in interest rate keeping the loan amount and period of loan constant. Or, you may wish to 'guesstimate' how your profit would change if you reduced on increased the sales price of an item because that might change the number of buyers. http://www.youtube.com/watch?v=jfRkXKgNVDs
Views: 33711 Dinesh Kumar Takyar
Save Excel file using data from cells & single click
 
07:42
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can save your MS Excel files automatically using the data from the worksheet cells for the filename. You require a macro attached to a command button to perform this activity with a single click. http://www.youtube.com/watch?v=xHkI4Nn5nKA For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 100340 Dinesh Kumar Takyar
How to Open Folder in Excel Using VBA
 
02:42
How to open a folder in Excel automatically using VBA. Details available at this link: https://www.exceltrainingvideos.com/how-to-open-folder-in-excel-using-vba/
Views: 6454 Dinesh Kumar Takyar
Transfer Specific Data from one Worksheet to another for Reports
 
11:14
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com/transfer-specific-data-from-one-worksheet-to-another-for-reports.html In the present training video we describe how to transfer specific rows of data from one worksheet to another using a 'for next' loop to quickly and easily create reports. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 274684 Dinesh Kumar Takyar
Adding and using a combobox on a userform in MS-Excel
 
05:21
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can add a combo-box to your user-form to amke data entries easier. Once the data is entered, the calculations can be automated and the data transferred to the Excel worksheet. Link to website: http://www.familycomputerclub.com/adding-using-combobox-on-userform.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 211654 Dinesh Kumar Takyar
Do while loop excel vba - revisited
 
06:31
Quite a few people experienced errors while running 'do while' loops in their worksheets and this was mostly due to not defining the variables used. Therefore we describe here the do while loop in Excel VBA for automating calculations and also building in an error due to non-defintion of a variable and how to correct the situation. For a do while loop to work correctly you need to define: 1. A starting point 2. Condition under which the loop should continue to work or stop 3. Move to the next data (x=x+1). 4. Keep looping by going back to first line of code - 'do while...' For more details you can log into http://www.familycomputerclub.com/excel/do-while-loop-in-excel.html.
Views: 34762 Dinesh Kumar Takyar
How to Display Multiple Charts from Excel Worksheet on UserForm
 
03:26
How to Display Multiple Charts from an Excel Worksheet on a UserForm automatically and navigate through the charts. More details including VBA macro code available at this web link: https://www.exceltrainingvideos.com/how-to-display-multiple-charts-from-excel-worksheet-on-userform/
Views: 3584 Dinesh Kumar Takyar
Increase or decrease cell value automatically using Excel VBA
 
05:58
If you wish to increase or decrease the worksheet cell value automatically you can use appropriately coded command buttons. Now try this out with dates and you'll be surprised! For more details and interesting links visit: http://www.familycomputerclub.com/increase-decrease-worksheet-cell-value-automatically.html
Views: 73911 Dinesh Kumar Takyar
Excel like calculations in word
 
05:39
Most of us work in MS Word to create invoices, letters, etc. and would be happy to do some more complicated calcultions right in this program. We discovered how to do Excel like calculations in MS Word and maybe this will help to solve some problems. For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 108081 Dinesh Kumar Takyar
Autofit Data in Excel Worksheets Automatically
 
03:36
You can automate the process of autofitting entered data in Excel worksheets using one line of code. For more details visit: http://www.familycomputerclub.com/Autofit-Data-Automatically-in-Columns-in-MS-Excel.html
Views: 59450 Dinesh Kumar Takyar
Convert MS Excel Formula to VBA code
 
05:39
How to convert an MS Excel formula to VBA code. For details visit: http://www.familycomputerclub.com/convert-ms-excel-formula-to-vba-code.html Feel free to subscribe to my channel. For more interesting videos on MS Excel: http://www.familycomputerclub.com
Views: 49769 Dinesh Kumar Takyar
How to transfer multiple rows of data from multiple workbooks into master workbook with VBA
 
19:16
We learnt earlier how to transfer one row of data from multiple workbooks to a master workbook using VBA. In thie video we learn how to transfer large amounts of data from multiple workbooks to a master workbook, how to access different files and turn off the Clipboard warning message using VBA. For details you can visit: http://www.exceltrainingvideos.com/how-to-transfer-multiple-rows-of-data-from-multiple-workbooks-into-master-workbook-with-vba/ For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 108431 Dinesh Kumar Takyar
How to transfer data from one workbook to another automatically using Excel VBA
 
14:30
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can use Visual Basic for Applications in Excel to transfer data from one workbook to another Excel workbook automatically. The process is simple once you understand the steps. It involves creating 3 variables or containers for data. Now we transfer the data from one workbook to the variables. Next we open the other workbook, locate the correct empty row and then the appropriate cells. Here we finally transfer the data from the variables into the cells and automatically save the workbook. Get a cup of tea or coffee or a diet coke and just work through the code. It's easy! Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 411991 Dinesh Kumar Takyar
Entering Dates in Excel worksheet using Calendar Tool - One Click Date Entry
 
03:57
Entering dates in an Excel worksheet is not as convenient as entering text or numbers. You can use the Calendar Tool or Control to make dates entries easier and less error prone. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 192369 Dinesh Kumar Takyar
Display all worksheets in listbox and print specific worksheet
 
06:35
Today we learn how display all worksheets in a listbox and print a specific worksheet by clicking a command button. We use a 'do until' loop to count all the worksheets and display them in a listbox when the userform initializes. Next we code a command button to print the sheet selected from the list box. This Excel training video is based on a 'comment-question' from one of our subscribers.
Views: 17517 Dinesh Kumar Takyar
Open PDF File Using Excel VBA
 
03:01
How to open a PDF file using Excel VBA.
Views: 46291 Dinesh Kumar Takyar
Get data from multiple sheets in multiple workbooks into master workbook with vba
 
05:35
How to get data from multiple worksheets in multiple workbooks into a master workbook with VBA automatically in the correct sequence. Details available here: http://www.exceltrainingvideos.com/get-data-from-multiple-sheets-in-multiple-workbooks-into-master-workbook-with-vba/
Views: 26564 Dinesh Kumar Takyar
How to subtract dates in MS Excel
 
05:55
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.comYou can subtract two dates in Microsoft Excel using the DATEDIF() function: DATEDIF(DATE1,DATE2,Unit) DATE1 = Start Date DATE2 = End Date Unit to be enclosed in quotes: "m" - complete calendar months between the 2 dates "d" - number of days between the 2 dates "y" = complete number of years bewteen the 2 dates "ym" -= complete calendar months between the 2 dates assuming the months are in the same year "yd" = complete calendar days between the 2 dates assuming they are in the same year "md" = complete calendar days between the dates assuming they were in the same month and same year. You can combine the 'datedif()' function andt the 'today()' function to calculate the age orf a person. Note: Use this function with caution since it sometimes gives erratic results particularly in the "md" calculations. http://www.youtube.com/watch?v=PbyAA69tHC0 For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 87385 Dinesh Kumar Takyar
Consolidate Data from Multiple Excel Workbooks using VBA
 
10:32
We can consolidate data from multiple Excel workbooks using VBA. This automates the complete process of data consolidation or summation. The process of consolidating data from different workbooks involves the following steps: (1) First we write the code for displaying the headers or labels like 'Item' and 'Quantity'. We also write the code to display the item names on the left below the header 'Item'. (2) Next we write the code to open all the workbooks from which we wish to consolidate the data (3) We then write the code to access the first cell where the consolidated data will appear for the quantity (4) We code to activate the workbook where the data will be consolidated (5) We write code to access the cells that contain the data to be consolidated for each of the workbooks (6) We code to close all the open workbooks except our workbook that contains the consolidated data In this manner we can automate the complete process of data consolidation from multiple workbooks using VBA in MS Excel. Complete details available at: http://www.familycomputerclub.com/consolidate-data-from-multiple-excel-workbooks-using-vba.html For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 100855 Dinesh Kumar Takyar
How to Get Data from Worksheet into User Form Combox and Text Boxes with VBA
 
05:08
First we get all the IDs into our combo-box using a looping process. Next we get the relevant data into our text-boxes based on our selection from the ID in the combo-box. This process using VBA automates the complete process of retrieving data from a worksheet into the combo-box and text-box controls of a user-form. The automation also reminds us of a Vlookup in Excel. The complete VBA code is available at this link: http://www.exceltrainingvideos.com/how-to-get-data-from- worksheet-into-combobox-and-textboxes-on-user-form/
Views: 60077 Dinesh Kumar Takyar
What is a macro in MS Excel
 
09:32
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com Many website visitors are confused about a macro and VBA. Well, VBA or Visual Basic for Applications is a programming language. Like any other language such as English, French or German it has its own grammar. You'll need to learn the grammar which is really not difficult. When we use the Visual Basic editor and write a program or set of instructions in VBA we create a macro. The macro has a name as you'll see in the video. I have made the video using Excel 2003 because in Excel 2007 and 2010 the interface is easier to use. Hope this video solves the mystery of the Visual basic editor, Visual basic for Applications and macros. You can visit this link to read more details: http://www.familycomputerclub.com/excel/what-is-a-macro-in-microsoft-excel.html Feel free to subscribe to my channel and write comments or email questions. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 236169 Dinesh Kumar Takyar
Automate Copying of Column Data from Sheet to Sheet Using Excel VBA
 
13:02
How to automate copying of column data from one worksheet to another using Excel VBA. Complete code and sample file available here: http://www.exceltrainingvideos.com/automate-copying-excel-column-data-from-sheet1-to-sheet2-with-vba/ Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 217028 Dinesh Kumar Takyar
How to Login into Website Automatically Using VBA
 
07:29
Alex wants to automate the process of logging into a website automatically using Excel VBA. He has the username and password for the website. Our video demonstrates how you can login automatically into a website like Gmail using Excel VBA: 1. Go to the Gmail website 2. View its source code to find out the labels used for the username and password 3. Start the Visual Basic Editor in MS Excel 4. Activate the following two items by clicking on Tools and then 'References...': •Microsoft Internet Controls •Microsoft HTML Object Liabrary 5. Next define two public variables 6. Now start writing the macro 7. Using a looping process access the username and password text-boxes automatically for entry of the relevant data 8. Then identify the 'submit' button, click on it and exit the for loop 9. To avoid error messages popping up write a few lines of code to ignore the errors You'll notice that the VBA code works well. You can access the VBA code here: http://www.familycomputerclub.com/how-to-login-automatically-into-website-using-excel-vba.html For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 140545 Dinesh Kumar Takyar
Delete Data from Excel Worksheet Database via a User Form
 
06:02
How to delete data from an Excel worksheet database via a user-form through VBA code. Details available at this website link: https://www.exceltrainingvideos.com/delete-data-from-excel-worksheet-database-via-user-form/
Views: 16672 Dinesh Kumar Takyar
Automated data scraping from websites into Excel
 
12:43
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can scrape, pull or get data from websites into Excel by performing a few simple steps. 1. record a macro to find out how one or many tables or data can be scraped from the website 2. Study the code carefully 3. Create an Excel sheet containing the links that get you the data from the appropriate web pages 4. Automate the process using a loop that creates a) New worksheets b) Automatically changes the link to the web pages that have the required data You can view the complete Excel VBA code here: http://www.familycomputerclub.com/scrpae-pull-data-from-websites-into-excel.html http://www.familycomputerclub.com/get-web-page-data-int-excel-using-vba.html Interesting Links: http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 505999 Dinesh Kumar Takyar
Automate rounding of decimal numbers MS Excel
 
03:30
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com When you work with numbers in MS Excel you'll often have decimal numbers which need to be rounded off because seldom do you need a precision upto 4 0r 5 decimal places. You can achieve the round-up or round-down in a variety of ways. The method described here to automate the rounding of decimal numbers in MS Excel is quite interesting using the 'IF' function combined with the MOD, CEILING and FLOOR functions. http://www.youtube.com/watch?v=fl_iY1RflKo For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 166329 Dinesh Kumar Takyar
Automation using do while loop Excel
 
04:11
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com Using loops or looping you can automate calculations and analysis of data in Microsoft Excel Common loops or looping processes are a 'do while' loop or a 'for next' loop. For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 114291 Dinesh Kumar Takyar
Print specific worksheet from Excel Workbook
 
08:07
A website visitor wanted to know how to print a specific worksheet from multiple worksheets in an Excel workbook. We used a command button and an input box to find a good solution. The user clicks on the command button. An input box opens up. The user enters a sheet number. Now we assign this number to the worksheets object and use 'printout' function to print the relevant sheet. Now what if the sheets are not numbered but have specific names. The solution to this problem also use Excel VBA but now the variable used is a string and we assign this string variable to a Sheets object. Again using the 'printout' function we print the specific named sheet once the user enters the name in an input box! More details available at: http://www.familycomputerclub.com/print-specific-worksheet.html
Views: 50101 Dinesh Kumar Takyar
How to manipulate PivotFields in Pivot Table using VBA
 
06:05
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com/how-to-manipulate-pivot-fields-in-pivot-tables-using-vba.html Today we learn how to manipulate Pivot Fields in Pivot Table using VBA.
Views: 34374 Dinesh Kumar Takyar
Compare two Excel Worksheets Cell by Cell Using VBA
 
11:14
How do you compare two worksheets cell by cell in the same workbook or in different workbooks? Excel VBA provides an elegant solution. First we define a few variables that can count the rows and columns so that we know how many cells are in use in the Excel worksheets. Next we assign the used ranges to the sheet with the maximum values. Now using a nested 'for loop' we access each cell in the used range and compare them. If the cells values are not equal we write them into a new workbook and also count the difference so that we tell the user about the number of cells that were not the same and also display both the values in the compared sheets. The displayed values are in the same cells in the new workbook as they appeared in the compared worksheets and highlighted appropriately. We also use a command button so that the user can perform the task with a single click! You can find the complete macro code here: http://www.familycomputerclub.com/compare-two-excel-worksheets.html
Views: 77964 Dinesh Kumar Takyar
Automatically Password Protect Excel Worksheet and Lock Cells after Data Entry using VBA
 
06:36
How to automatically password protect an Excel worksheet and lock cells after data entry using VBA so that the data entry operator cannot make changes without a password. Complete VBA code and sample Excel file available at this link: http://www.exceltrainingvideos.com/automatically-password-protect-excel-worksheet-and-lock-cells-after-data-entry-using-vba/
Views: 38699 Dinesh Kumar Takyar
Transfer Data from Multiple Workbooks into Master Workbook Automatically
 
18:14
We can transfer data from multiple workbooks into a master workbook automatically using Excel VBA. Sherin has created a template file with specific headers. Her suppliers have also been instructed to have the same headers with the relevant data below them. Now when the suppliers send her the workbooks by email, Sherin transfers them to a common folder where she has her template or master file. She wishes to now automate the process of transferring the relevant data from the suppliers files to her master file. The process involves the following VBA code: (1) Find out how many suppliers files are there in the folder (2) Open the files one by one (3) Copy the relevant data (4) Close the suppliers file (5) Paste the data into the template or master file (6) Loop through all the files using the LEN function with the DO WHILE loop Finally we can call our subroutine or macro every time we open the workbook to automatically transfer the data from the suppliers files to our master file. Code and further details: http://www.familycomputerclub.com/transfer-data-from-multiple-workbooks-into-master-workbook-automatically-using-vba.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 473199 Dinesh Kumar Takyar
Protect Worksheet and Allow Specific Cells Editing Using Excel VBA
 
06:52
Often you wish to help the data entry operator by protecting formulas and cells in an Excel worksheet and allowing only certain areas of the worksheet for data input or editing. You can do this using standard methods as described here: http://www.familycomputerclub.com/excel/protecting-formulas-worksheets-in-excel.html Or, you can use use Excel VBA if you are planning to automate your project as shown in this training video. More details here: http://familycomputerclub.com/protect-worksheet-using-excel-vba.html
Views: 60470 Dinesh Kumar Takyar
how to avoid duplicate entries in excel using data validation
 
02:46
You can avoid or prevent duplicate entries in Excel automatically by using a combination of data validation, absolute cell references and the countif function. We have discussed data validation, cell references and the countif function in the earlier videos in detail. The process is very useful when you have to enter many item IDs or numbers.
Views: 11865 Dinesh Kumar Takyar
Calculating time in MS-Excel
 
05:28
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com Microsoft Excel makes calculations with 'time' very easy. So if you wish to calculate the monthly payments for your employees you need to have a start time, an end time and the payments per hour. Whether the person works during day-shifts or night-shifts, Excel can help make the calculations easy and automatic. Just ensure that you enter time in the format x:y:z, where x = hours, y=minutes and z=seconds if you wish to have seconds in your data else just use x:y, i. e. hours and minutes separated by ':' (colon). If you want enter time as 'am' or 'pm' just add a 'p' after the time. If you don't write anything after the hours, minutes and seconds MS-Excel assumes it is 'am'. If you use the '24-hour' clock, Excel has no problems with 'am' or 'pm'. Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 378153 Dinesh Kumar Takyar
Transfer Specific Worksheet Range Data from one worksheet to another based on condition
 
18:11
Our Excel training videos on YouTube cover formulas, functions and VBA or macros. Useful for beginners as well as advanced learners of Excel VBA or macros. New upload every Thursday. For details you can visit our website: http://www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/ We use a 'for next' nested loop to ensure that only when the ID or name matches that the specific worksheet range data is transferred from one worksheet to another.worksheet range quickly and easily. For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU
Views: 138798 Dinesh Kumar Takyar
Copy auto filtered data to another worksheet automatically with VBA
 
11:48
How to copy auto filtered data to another worksheet automatically with VBA. Complete VBA code available here: http://www.exceltrainingvideos.com/copy-auto-filtered-data-to-another-worksheet-automatically-with-vba/
Views: 33542 Dinesh Kumar Takyar