Hi all!
I have limited exposure to macros and was hoping to receive some assistance.
My original data sheet has 43,000 rows and 44 columns. First, I must execute a custom sort of 16 columns. Second, whenever one cell is not identical to the cell above it (for 15 of the 16 sorted columns), I need to insert a blank row. Manually, this will take weeks.
Here is an example of the logic that I'm trying to use:
=IF(AND(A3=A4,B3=B4,C3=C4,D3=D4,E3=E4,F3=F4,G3=G4,H3=H4,I3=I4,G3=G4,H3=H4,I3=I4,J3=J4,=K3=K4,L3=L4,M3=M4,N3=N4,R3=R4),Do Nothing, Insert Row below Row 3).
Would someone who is well educated in marcos be able to write such a thing?
Please advise,
Ross
I have limited exposure to macros and was hoping to receive some assistance.
My original data sheet has 43,000 rows and 44 columns. First, I must execute a custom sort of 16 columns. Second, whenever one cell is not identical to the cell above it (for 15 of the 16 sorted columns), I need to insert a blank row. Manually, this will take weeks.
Here is an example of the logic that I'm trying to use:
=IF(AND(A3=A4,B3=B4,C3=C4,D3=D4,E3=E4,F3=F4,G3=G4,H3=H4,I3=I4,G3=G4,H3=H4,I3=I4,J3=J4,=K3=K4,L3=L4,M3=M4,N3=N4,R3=R4),Do Nothing, Insert Row below Row 3).
Would someone who is well educated in marcos be able to write such a thing?
Please advise,
Ross