aruncr
12-30-2019, 06:02 AM
Hello Experts,
I have a sheet with 6 columns.
Condition 1 - A blank row needs to be inserted whenever the Item (Column D) changes. I have the macro and it is working fine.
Condition 2 - Within an Item if a trade is closed off a blank row needs to be inserted, like
- If there is a Sale of 20 and then there is a purchase of 20
- If there is a Purchase of 100 and there are sales of 50, 25,25
Request your help for fulfilling Condition 2.
I am herewith attaching the excel file.
I have a sheet with 6 columns.
Condition 1 - A blank row needs to be inserted whenever the Item (Column D) changes. I have the macro and it is working fine.
Condition 2 - Within an Item if a trade is closed off a blank row needs to be inserted, like
- If there is a Sale of 20 and then there is a purchase of 20
- If there is a Purchase of 100 and there are sales of 50, 25,25
Request your help for fulfilling Condition 2.
I am herewith attaching the excel file.