Forum Discussion
Put =SUM in every other cell.
To save me the trouble of deleting every other cell with a =SUM total in it, I want the formula where i can drag the cursor along a line and it skips every other cell.
Example:
Copy cells E13 to BX13.
Insert in the desired row at column E.
-----------------
another variant would be with VBA code:
Sub Copy_Cells_Nlino ()
Dim NextEmpty As Long
NextEmpty = Table1.Cells (2, 1) .End (xlDown) .Row + 1
Table1.Rows ("2: 6"). Copy
Table1.Cells (NextEmpty, 1) .Select
ActiveSheet.Paste
End Sub
'From German translate, untested.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.