Why use VBA when we can use transpose : This macro is made for those who work on large and complicated data files. To debug the MACRO you have to press F8 in Microsoft Visual Basic. Suppose if you have a larger spreadsheet where you have to backup and view,sort around 30 columns rom one part of the sheet to another part of the worksheet and on a daily basis. Then how will you do it. Yeah we know transpose..but…
It is very simple to make your spreadsheet editable for many other users via Google docs. Users will be able to edit and update the worksheet from any place. Following are the steps : Open Google Docs spreadsheet homepage click here . In the page click the folder icon (See image) Create and choose Files…>> upload After uploading file click it and open it. Now how to make it shareable and editable for any other person Now to share this…
This is a simple sheet that can support excel as well as MAC numbers. To download this sheet you have to click the image.
This one is a fine sample spreadsheet to construct a population pyramid in excel sheet, user have to fill in data in % divided into males and females along with their age.After the data input chart will be automatically constructed in the same sheet but in different tab provided. Easy to understand and use and understand. If you have data of actual males and females instead of percent you can arrange the data according to this tutorial.It is quite easy…
I am sharing few blank cue sheet template’s with you. These can be downloaded and filled by the user information such as publisher and composer is needed to be filled in these sheets. Here is another one it is sports music sheet as it is uploaded to onedrive. You have to click on more… and then choose download option
In this tutorial i will tell you how to use some properties like Table filtering and sorting in MS Access and i will also show you how to create a form in this software. First of all we will need a dummy data sheet or a example sheet for testing, First of all lets start with sorting and filtering You have to click on the home tab to view these options. For example you want to arrange this data by…
Track your purchase per item wise using these worksheets. They support most of the spreadsheet programs like excel,google sheets and others. You can convert them to open office format also. There are various tools available online that can do this for you in few minutes. MAC users try this : You can download these sheets and upload them to Office web Apps that will allow you to edit files and save them online. For it you need a Live…
Here is a Excel VBA code that will allow you to backup your active worksheet as per your defined time. It is by default “15 seconds” but you can change the period as per your needs. Create a folder and name it “Test” in the partition C:\ The code in a module —————————— And this code is in a workbook module
I have lots of Ms access and Excel tutorials resources (links from internet,videos and PDF’s along with templates and example sheets, some of them are really important and can help a lot, but the thing is that I want to know which one works for you. I basically hate reading long tuts as well as long videos as they consume a lot of time and in the end you might get the desired result or not. I will be making…
Here is an example spreadsheet to plot industry strategy in excel. Click on the image to download the file.
