I need a macro that will help me insert a blank row above certan rows

[scarlettw123]

I need help! I have a spread sheet that contains part numbers in column C. All the information is exported from SAP to excel. I filter the part numbers and insert a conditional format that highlights the cluster of cells in column see with duplicate part numbers. I then insert a blank row above the rows that contain the duplicate part number and put a sum if formula in column D (On the new blank inserted row) to count the number of that specific duplicate part number in Column C. Can someone help create a macro for me that will automatically generate the conditional format, insert the blank rows, and count the number of duplicate cells? Please help!

Example:

A B C D
SEQ. PC PART QTY
1 5 1234 14
2 8 1285 16
3 8 3584 15 <----Insert blank cell above this row and put the # of dups. in column D(2)
4 3 3584 20
5 1 1586 0
6 2 2541 0<-------Insert blank cell above this row and put the # of dups. in column D(3)
7 1 2541 2
8 4 2541 3
**This is just an example but it goes on and on and on

[TonyS]

Something like this!

Please Login or Register  to view this content.

[scarlettw123]

This works great! Instead of having the information in the red show up in column 4 how can I change it to another column?

[scarlettw123]

This works great! Instead of having the information in the red show up in column 4 how can I change it to another column

[TonyS]

Change 4 to whichever column you like in this statement. I hope that's what you're asking.

Please Login or Register  to view this content.