VBA Automation

Role &

1. Create a User Defined VBA function to perform a vlookup for nth value from a excel range. Please do not use excel or worksheet functions
2. Write a program which will give a pop-up to the user with Yes and No buttons. As long as the user keeps clicking Yes, the pop-up will re-appear and will end only upon selecting No. You are not supposed to use any conventional Loop (For, Do, while…)
3. Write a function to break a word into letters and return an array type variable containing the splits. Use this function in a Sub to pass on a word and get the result array and loop through to print all splits in a MsgBox
4. Write a sub to copy a range of excel data table and paste it in another sheet's cell that corresponds to the cell co-ordinates of row = rows in the copied excel table and column = columns in the copied excel table
5. In a column of data there are a few blank cells. Write a sub to fill all the cells with the value of cell write above it. Try keeping it as small as possible
6. Write a sub to connect to a database (SQL / DBMS) and write some data lines to a table in it. Keep the code clean and brief (use some sample data as DBMS)
7. Set a pivot table in such a way that whenever the size of source data is changing the Pivot should auto adjust instead of requiring to change source size manually
8. Write a program to read through the outlook mailbox and fetch emails that has specific keywords in subject line
9. Write a user defined function which will combine the functionality of both vlookup & hLookup
10. Web Scrapping - Write a macro which will get the latest share price for any company from google and print in excel.

Preferred candidate profile

Please Note:

1st round telephonic

2nd round virtual

3rd round f2f

Perks and benefits