Hello,

Problem;
I have a vlookup set up between 2 worksheets with the possibility of
results. I need to record all possible results in column C under eac
other. Is there a way insert rows to include all possible results usin
VB code. I have tried a few other way using formulas but have come th
conclusion that VB code must be the answer. I have not dealt with
high level of VB so a detailed response would be greatly appreciated.

Example;
I am trying set up a spreadsheet to calculate bonuses, depending o
your position there are certain objectives. In 1st sheet is a list o
employees and their positions and on the second is the position wit
their objectives. I want to extract the objectives for each employe
according to their position.

SHEET 1
Collum A Collum B
John Smith Sales Manager
Greg Hobbs Branch Manager

SHEET 2
Collum A Collum B
Sales Manager Revenue
Sales Manager Income
Sales Manager America's & Pacific RAC
Branch Manager Utilisation
Branch Manager Branch Revenue
Branch Manager Pre Tax Income

Result;
SHEET 1
Column A Collum B Collum C
John Smith Sales Manager Revenue
Sales Manager Income
Sales Manager America's & Pacifi
RAC
Greg Hobbs Branch Manager Utilisation
Branch Manager Branch Revenue
Branch Manager Pre Tax Income

Thank

--
Message posted from http://www.ExcelForum.com