Sometimes, you might need to create a desktop shortcut to Onedrive documents. Below is a method for Excel documents which can be used for any MS Office document. First, you would need to find the path of Excel.exe on your computer.
Excel Quiz 45
Tips & Tricks 175 – Color Code for Official Color of Excel
Everybody sees the dark green color of Excel. The color code for this color is
VBA – Delete All Blank Rows
This macro will delete all blank rows from a sheet.
Tips & Tricks 174 – VBA – OR Condition in FIND
FIND is a very powerful function in VBA but it doesn't support OR condition. Hence, if you want to find say two values "A" or "B", then you can code an array within FIND. To do OR in FIND, you will need to use following code (this is a sample code only, there can be…
Tips & Tricks 173 – Data Validation for Case Sensitivity
There are scenarios when you want to put a data validation which is case sensitive. Hence you want USA to be entered as USA not as usa or uSA or uSA so on. You just want all capitals. Similarly, sometimes you need only small letters say maverick. Hence, not Maverick, mavericK etc.
Excel Quiz 44
Tips & Tricks 172 – Calculate Next Working day if date is of Weekend / Holiday
Suppose you are given a date and you are asked to calculate next working day if date is of weekend. If date is a regular workday, then you should show the same date. For example – 8-Mar-19 is a working day. Hence, you should show the same date. But if this is either 9-Mar-19 or…
Downloads 20 – Excel based Consolidated Minutes of Meeting (MOM) Template
Download Link – MOM_Cumulative While earlier MOM template was or individual meetings, this MOM template can be used for all meetings held. Advantage is that you have running records of attendance, discussion and action items.