Hello Friends,

I am new here and new to Excel Programming too. I have a issue.

In Employee1 workbook, I have many employee records with first name,
last name, title, ssn ......., year 1, amount 1, year 2, amount 2 ..
columns.

My issue is to copy these specific records from the above workbook and
paste it in a new workbook so that the year and amount are shown
individually for every employee.

Sample:

FName LName Title SSN Gender DOB Address1 .. .. Year1 Amount1 Year2.
Bourne Cyber Mr 123 M 1/1/01 jj 1991 20000 1992

I need the output format in a different file as

Fname Lname Title SSN Year1 Amount1
Fname Lname Title SSN Year2 Amount2
Fname Lname Tilte Ssn Year3 Amount3
Fname2 Lname2 Title2 SSN2 Year1 Amount1
Fname2 Lname2 Title2 SSN@ Year2 Amount2


This is just a sample , It may contain many records. Basically i need
to loop it.

Please Help.
Urgent.

Abhi