Insert new row based on condition ?

[ramshakku]

Hi,

My requirement is :-
A B C
1000 500 500
500
300 300 0
475 275 200
200
650 650 0
400 400 0
300 100 200
200


IF A - B > 0 (C), new line needs to be inserted automatically with the pending value as per the example.
How to achieve the expected ? Please treat this as most urgent.
Thanks in advance.

Regards
RAM

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ramshakku]

Hi Sixthsense,

I have uploaded my issue in the separate excel as requested by you.
Kindly help me to arrive my desired output at the earliest please.
Thanks in advance.

Ram.

[Trebor76]

Hi ramshakku,

Welcome to the forum!!

Though there's no attachment I think this is what you're after:

Please Login or Register  to view this content.

If this doesn't meet your needs you'll have to try to attach a workbook again as Sixthsense has nicely documented.

Regards,

Robert

[ramshakku]

Hi Robert,

I have uploaded my issue in the main thread.
Anyway once again I am uploading the same here for your scrutiny.
Please do the needful.

Regards,
RAM

[Trebor76]

Hello robert,

Please review my attachment and provide me the necessary VB Code to proceed further.

Regards,

RAM

Please do not PM members for help as it's against forum rules (Rule 4 from here to be precise).

I'm glad you posted the workbook as your actual requirements are quite different from your request!!

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

[ramshakku]

Hello Robert,

Thanks for the update.
Sorry for disturbing thru PM.
Will keep in touch with you.

Regards,
RAM

[ramshakku]

Hi Robert,

I need just more validation in that Code.
If Item Number and Date combination already exists, the new line should not be created.
Kindly help me to achieve the above validation.
Thanks in advance.

Regards,
Ram.

[Trebor76]

If Item Number and Date combination already exists, the new line should not be created.

I don't know what you mean as the item and date combination already exist for each line.

You'll need to attach another workbook with a before and after scenario.

[ramshakku]

Hi Robert,

The Last line of the every Item only should be validated.
Based on that new line needs to be created with pending quality.
Please do the needful.

Regards,
RAM

[Trebor76]

Try this:

Please Login or Register  to view this content.

Robert

[ramshakku]

Thanks Robert. Thanks a lot

Ram

[Trebor76]

You're welcome

If you could mark the thread as solved it would be appreciated.