VBA Basics / My First Steps to Programming (Lesson 1)

Objective

Understand what is Visual Basic, how it is embedded in Office applications, what it can do and basic idea of using it.

VLOOKUP Multiple Occurrence

Objective

Many a times, while searching a list, the searched text/value may appear more than once. Standard VLOOKUP will return first occurrence from top. The question is how to find second, third or fourth occurrence?

How to Show Progress Bar in Excel / Macro

Objective

Like modern software, while your Macro/code is rendering a time consuming service, a percentage completion status should be shown to the user.

Copy Data on visible cells only (Skip hidden Cells)

Objective

Paste data on visible cells only, hidden rows/cells should not be replaced during Copy / Paste process.

About this blog/site

What you should expect:
On this blog I will be sharing my knowledge and solutions to Excel problems for which my circle contact me on day to day basis.