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
Last edited by expert40 : March 6th 12 at 03:33 PM
|