Have any questions? Just call us 061 361 3802
April 26, 2016
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 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.