Find duplicate cell, insert row below, calculate VBA

[BanaBrian]

Greetings,
After searching the forum, I cannot locate anything similar to this scenario, so here it is:
1. Locate duplicate part numbers (Column C).
2. When identified, insert a blank row below
3. Copy cells above blank cell in Columns A, C, D, and E
4. Concatenate the two cells above blank cell in Columns B and F with " / " between
5. Sum the two cells above blank cell in Columns G, H, I, L-BI
6. Calculate blank cells in Columns J and K (Ex. I4+H4-G4)

The attachment has the before and after scenarios.
Thank you very much for your consideration and I look forward to hearing from the resident VBA experts.

 

[dermie_72]

For the duplicate side of things if the data is in order, you can pick a column, and use:

=if(A1=A2,1,"")
Run that down (Autofill Down)

if it's not in order, then use:

=if(countif(A:A,A1)>1,1,0)


That will make it easy to identify where you need to act. Everything that has a 1 is a duplicate.

For the balance of the request, you could record the requirements in excel, and then replay it as required.

If you're not proficient in VBA code, then try this:

http://www.mrexcel.com/forum/excel-...visual-basic-applications-beginners-book.html
http://www.mrexcel.com/forum/genera...isual-basic-applications-books-beginners.html

Best of luck