Create separate workbook from worksheets VBA
Split worksheets into separate files Macro to create multiple workbooks from a master worksheet Recently as part of a consulting...
WHAT TO BACKUP WHEN CHANGING LAPTOP
I have changed around 5-6 laptops in the last 10 years, I know that's not good but I have to due to various reasons, sometimes to get a...
Challenge - VBA Challenge #901 (Find if the number is even)
Starting a series of challenges on VBA. Will extend this to SQL, Excel, Power BI, Tableau. Feel free to drop in a solution in the...
Auto Email Drafter - Mail Merge Outlook
You love mail merge but I am sure that once in a blue moon when you have to do it you will have to google it and see how to create...
SQL like with asterisk * works in MS-Access Query but not in VBA ADODB
I recently encountered a problem while writing a query for an excel application where I use ADODB to retrieve a list of items from the...
Stop computer from locking windows and keep status Active on Skype / Teams / Jabber using VBA scrip
With the pandemic pushing almost everyone to work from home and most of us are required to stay active on collaboration tools even if...
TEST YOUR EXCEL SKILLS IN EXCEL
So you want to know how good you are in excel then make sure you download our test now. Its not a multiple choice question style test but...
FREE SQL TRAINING FOR HYDERABAD STUDENTS
Hi All- There has been a request from most of the students attending excel and VBA classes to show what SQL queries are and how SQL can...
25 Most used shortcuts in Excel if you are a Data Analyst
Most used shortcuts on Excel in order of their usage on an average.
Using Offset Function in Excel
This article shows you how to use offset function in excel in an easy and interesting way.
