nvnazeer
01-15-2008, 11:08 PM
Gents,
I need a little more help with my Spreadsheet. I have attached the spreadsheet.
The Original spreadsheet is as shown in sheet1. For all items that have same the same "CMN Part No"., I want to automatically add the corresponding values under quantity column and replace this value with the added quantity on the first row and then delete the rows below(having the same "CMN Part No.') for which the quantities are now added to already in the first row.
This needs to be continued whenever the CMN part No. is the same for adjacent rows.
The end result required is shown on Sheet2.
Since my spread sheet is quite big and has several rows which are with unique "CMN part No." and others with same "CMN part No:" repeated. The program should skip the ones which are unique and then addup the quantities where the CMN part No. is same and delete rows whose quantites have been added. Of course the spreadsheet will be sorted by "CMN Part No." so that the rows with the same CMN part No. are together.
Thank you in advance for the help
Nazeer N.V
I need a little more help with my Spreadsheet. I have attached the spreadsheet.
The Original spreadsheet is as shown in sheet1. For all items that have same the same "CMN Part No"., I want to automatically add the corresponding values under quantity column and replace this value with the added quantity on the first row and then delete the rows below(having the same "CMN Part No.') for which the quantities are now added to already in the first row.
This needs to be continued whenever the CMN part No. is the same for adjacent rows.
The end result required is shown on Sheet2.
Since my spread sheet is quite big and has several rows which are with unique "CMN part No." and others with same "CMN part No:" repeated. The program should skip the ones which are unique and then addup the quantities where the CMN part No. is same and delete rows whose quantites have been added. Of course the spreadsheet will be sorted by "CMN Part No." so that the rows with the same CMN part No. are together.
Thank you in advance for the help
Nazeer N.V