09-21-2020 09:24 AM
09-21-2020 10:14 AM
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.
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.
09-21-2020 10:38 AM
Perhaps you mean
in D13 and drag it to the right. Same for other rows with total.
In Totals sheet you may use INDEX/MATCH to pickup sums from Mavan Teams sheet, but I'm not sure what is the logic for different Totals tables.