Insert new row based on values

[mklindquist0815]

Hi,

I have an excel spreadsheet that has the following columns/data:

| STUDENT | ITEM | NETAMT | PREVPAID | NEWAMT | REVERSAL |
| 1234567 | 1234 | 0.00 | 866.00 |
| 1234567 | 4321 | 615.50 | 1256.50 |

I have the above excel spreadsheet that I would like to perform a calculation on in addition to adding a new row depending on certain values. Here is my IF statement and below this is what I would like the final result to be. Calculation = If netAmount > 0 then NewAmount = previousPdAmt, ReversalInd = Y and INSERT a new row with New Amount = netAmount, ReversalInd = N ELSE NewAmount = previousPdAmt.

| STUDENT | ITEM | NETAMT | PREVPAID | NEWAMT | REVERSAL |
| 1234567 | 1234 | 0.00 | 866.00 | 866.00 | Y |
| 1234567 | 4321 | 615.50 | 1256.50 | 1256.50 | Y |
| 1234567 | 4321 | 615.50 | 1256.50 | 615.50 | N |

Is this possible?

[Richard Buttrey]

Hi,

Here's one macro

Please Login or Register  to view this content.

Usual caveat. There were only two rows of data (we usually like a good representative sample) so if your actual data has a different layout or is not consistent with these two rows then there may be unexpected results.

[mklindquist0815]

There could be more than 2 rows in the first layout. I just didn't want to list everything. There could also be more than one student ID.

[Richard Buttrey]

There could be more than 2 rows in the first layout. I just didn't want to list everything. There could also be more than one student ID.

I don't understand the implications. Are you saying that you don't want to process every row in its own right?