Excel BeforeDoubleClick Delete Multiple Cells in a Given Row : <p>This seems so simple, but I'm having a heckava time finding an answer. I'd appreciate any help. </p>

<p>On a Worksheet I have five columns of data, in three groupings:</p>

<p>A1 B1 C1 <strong>D1</strong> E1 ---- J1 K1 L1 <strong>M1</strong> N1 ---- O1 P1 Q1 <strong>R1</strong> S1</p>

<p>A2 B2 C2 <strong>D2</strong> E2 ---- J2 K2 L2 <strong>M2</strong> N2 ---- O2 P2 Q2 <strong>R2</strong> S2</p>

<p>A3 B3 C3 <strong>D3</strong> E3 ---- J3 K3 L3 <strong>M3</strong> N3 ---- O3 P3 Q3 <strong>R3</strong> S3</p>

<p>And so on for 200 rows.</p>

<p>What I want to be able to do in Excel is doubleclick on a cell in the D, M or R column and delete the respective grouping and have that section of the row shift up. For example, I doubleclick on <strong>D2</strong> and A2, B2, C2, D2 and E2 are deleted, shifting up A3, B3, C3, D3 and E3. All other cells remain the same. </p>

<p>In advance, thanks for any suggestions.</p>
