Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 3
Default 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
Attached Files
File Type: zip Working on final11.zip (22.2 KB, 36 views)

Last edited by expert40 : March 6th 12 at 03:33 PM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to Edit Contents of Cell TKS_Mark Excel Programming 4 January 9th 08 03:01 PM
macro to edit cell contents adgorn Excel Programming 4 October 14th 06 09:35 PM
creating macro to edit cell contents mar10 Excel Programming 1 August 4th 06 02:51 AM
edit the contents of a cell using a macro stinson Excel Programming 1 November 29th 05 07:20 PM
How can I edit cell contents with a macro in Excel? Mind the gaps! Excel Discussion (Misc queries) 2 March 23rd 05 08:51 PM


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"