Excel vba sample files

I just need to create a code which help us to update the data from Execl sheet to web portal like DOB once the data is updated and saved then it will move for next data to be updated. If you can help me with any suggestion or how can we do this in Excel VBA that will be great help.

Can anybody help me about from where i can download the free financial macro based reporting formats. I need it really on urgent basis. I want to search a criteria in a range present in worksheet and get the value and copy paste the criteria that is not present in that particular range in a different range. How to do that without using vlookup function in vba? Hi Sir Please get me the vba code to transfer data from master workbook to multiple worksheets based on a condition for eg. As a new to VBA i find it very interesting and useful all the information and began to practice it..

Sir, I like to know how to transfer data from a formatted text file with many Dashes, Lines, uneven spaces and Multiple columns into an excel work book.

Hi Rakesh, We will be launching our e-book and will be available soon for downloading. And ur tutorial n specially example file wher we can see the codes in action are super helpful please upload that file so we can learn things much faster thank you for providing us this great website. Dear sir, Here is my problem that i want to copy data from one sheet to the empty cells of another sheet.

We are still preparing our tutorials, available soon. We will inform you once its ready. Dear Sir, thanks for sharing your knowledge so generously. HI sir Can any one help for inserting row. I have around row. But i am not able to do. Pls help. Thanks in advance. I am looking for a code for add a new row when I fill in my userform in Excel. I want the info that I fill in on my userform transferred to cells in my sheet and when I put new information into the userform the code adds a new blanco row.

Could anyone help me? You must be logged in to post a comment. View Details. Go to Conditional statements are the crucial to write any program to automate the any task. Examples on sub-procedures will help you to learn how to write a simple procedure and procedures with parameters. A Simple Supermarket Application to show examples on adding new items, clearing, selecting multiple items and changing various options of ComboBox. A Sample Supermarket Application to show examples on adding new items, clearing, selecting multiple items and changing various options of ListBox.

Download the files and see the examples one Collections. Collection is an object contains group of objects having similar characteristics with same properties and methods. In this file you will see the code to call a UserForm from your Worksheet. You can find simple examples on Excel Workbook and Worksheet Events. This example will show the procedures to export the data from Excel worksheet to a Text File and import the data from text files to a Excel worksheet.

A very basic interactive dashboard example explained helps you to create interactive dashboards. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time.

This page describes all the amazing new features and options that come with our premium templates. I will give the complete explanation on each file attached hopefully with in this week in a separate post and add that link beside the downloads, so that is is easy to discuss any thing related to that particular file or topic. Sir, Thanks for uploading the files and it was easy and superb and i am waiting for more uploads in the future. If you save your file as. But you can not open. Can you explain the Difference between Array and Loops…I mean in what scenarios we use these.

Could you please explain me in terms of Interview point of and practical work scenario with better examples if possible. Example: If you want to format the a Range contains values less than zero in red color, no need write one statement for checking one Cell. You can avoid this using loops and one statement enough to do the same task for entire Range.

We will see these topics with more explanation in our blog soon. And will upload the examples on pivot table ASAP. I am facing lot of problem in some of my official daily tasks in terms of Reporting and wasting time bcz of manual work. Thank you very very much and can i get the exact task solution for TASK 3?

And can you post our last class project?. Once again thanks for your support. Please upload more example files as all of our batch mates are waiting eagerly and getting calls frequently.

If possible kindly do alternate instead of slice usage as most of us not having excel I told to all and they are following it seems……. It is very nice specially its good for beginers. Once again thanks for sharing your knowledge with us. Added a simple dashboard, click on the Read More for more explanation on this simple dashboard.

Added a simple Interactive dashboard. You can have a look and ask me if you have any questions. I have prepared for you a number of ready to use VBA Excel Macro examples with great functionality that you can use to optimize your work. The next paragraph deals with Excel macro installation. Skip this part if you are already familiar with this. Very useful macro, as it shows how to copy a range of data from inside vba and how to create and name a new workbook.

You can easily upgrade it to fit your own requirements:. Occasionally, large Excel files contain hidden lines for better clarity. As previously mentioned, blank cells interfere with data processing and the creation of pivot tables. Here is a code which replaces all blank cells with 0. Just double click any cell from a column you would like to sort. NB: You need to put the code in Sheet 1 and not in a module to work:. Occasionally, data in the workbook contains additional spaces spaces that can interfere with data analysis and to corrupt of formulas.

Sometimes there are duplicate values in the several columns we would like to illuminate. When you run this code, a window will prompt. It will ask you the value you want to compare the cells you have selected. This is extremely useful when you work with functions that take strings, however, someone entered the string with a mistake and your formulas are not working. Here is how to fix this issue:. Here is how to create a pivot table from MS Excel version. Especially useful, when you are making a custom report every day.

You can optimize the pivot table creation in the following way:. My favorite VBA code.