Make Static code Dynamic

In Column G of sheet7 I have a list of initials (two characters each).
In Column H sheet7 I have a list of names that correspond to Column G.

In my code below I hard coded the "initials" (G) and "names" (H)
Im trying to make the code dynamic where column G and H could have added or removed without editing the code.
Simply not sure how to go about this?

Please Login or Register  to view this content.

Any hints, tips or examples is appreciated.

Hi

Upload the sample data file with the required output...

See attached file.
Sheet1 (Main Page) contains the macros in my initial post.

I have attempted this code:

Please Login or Register  to view this content.

But I get an error:

Run-time error '424':
Object required

at "sLogin2 = sht7CellG.Offset(0, 1)"
The data for "sht7CellG.Offset(0, 1)" is correct!?

This has become a problem of passing an Objects value to a string.
I started a new post to cover this.
http://www.excelforum.com/excel-prog...90#post2812890