Get acquainted with amazing service here

Have any questions? Just call us 061 361 3802

April 26, 2016

Set Tasks Excel Outlook

Using the below VBA code you can set tasks excel outlook by simple entering the date and allocating the information.

Many people keep a list of things to do — on paper, in a spreadsheet, or with a combination of paper and electronic methods. In Microsoft Outlook you can combine various lists into one, get reminders and track task progress.

April 26, 2016

Printing Excel Auto Filters

Printing excel auto filters on spreadsheet, we will use the Auto filter option and Print option in Microsoft Excel 2010.

Auto Filter: – This option allows us to filter the data based on content of cells and conditions applied on them.

We can filter the data according to the particular text, month, date, number, cell color, font color, etc. Even we can sort the data as per the number, text, cell colors, and font colors, etc.

Using the below code we can run a macro to print an entire spreadsheet filtered by data in a specific column.