Macro edit to add before contents to the new row
 

Hi ,
I have the follwing excel sheet which i have attached.And i have macros in the sheet.

When i run the macro in the Working sheet it will do the allocation.

When a person is alloted in two projects new empty row was inserted with project and allocation..

Now i want the previous row data .

For Ex:

Take the example of Ramana before running macro

Ramana V Programmer Offshore India Café Fixed Run Ram 200 $5,138.00


After running macro the data looks like


Ramana V Programmer Offshore India Café Fixed Run Ram 200 $5,138.00 $0.00 Project1 767.4
Project2 3003.75
Project3 1366.85


But i want the data look like


Ramana V Programmer Offshore India Café Fixed Run Ram 200 $5,138.00 $0.00 Project1 767.4
Ramana V Programmer Offshore India Café Fixed Run Ram Project2 3003.75
Ramana V Programmer Offshore India Café Fixed Run Ram Project3 1366.85



please try to help me or direct me