Insert line and copy data of previous line with certain changes

Hi All,

Sir I have to insert row after each line with the following process. I have more than 15000 lines to do so.
1 Insert line after each original line.
2 Copy previous rows data in the inserted line
3 Copied line with following changes
a Column O amount should be reversed.. i.e positive should negative amount and negative should positive amount
b Assignment cell (column D) should have data of offset acct of column Q of original line
c Offset acct (column Q) should have account number of Assignment cell of column D of original line

I have attached test file for your reference. Changes are shown in Yellow color.

Thanks in advance.

Regards,
Vijay

can you show example for 4 rows of data?

Hi John,

Its great to see result except condition 3 a of my requirement is not meeting i.e. reverse sign for column O amount. If amount is negative should become positive in inserted line and if amount is positive it should become negative in inserted line with negative sign "-"

Thanks in advance.

Regards,
Vijay

You can try this..

Please Login or Register  to view this content.

Cheers!!

Originally Posted by vijayca

Hi John,

Its great to see result except condition 3 a of my requirement is not meeting i.e. reverse sign for column O amount. If amount is negative should become positive in inserted line and if amount is positive it should become negative in inserted line with negative sign "-"

Thanks in advance.

Regards,
Vijay

Try:

Please Login or Register  to view this content.

Hi John,

Thanks a lot. It works like magic. Gr8.

Regards,
Vijay

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.