Copy to last row

[Wabos]

I have a workbook that has 2 sheets, "Roster" and "Team".
I want to be able to copy specific cells from the current row in Roster to the 1st blank row in Team.
From current row Col A to Team Col E
B to C
C to B

I have attached an example.
Any help would be appreciated.

Wabos

[Wabos]

I have made some progress with the task but continue to have a problem, specifically Column A in Roster contains a formula/function and I want to copy/paste only the Value in Column E in Team.

Please Login or Register  to view this content.

I have attached an updated workbook.

Thanks,
Wabos

[Wabos]

While probably not the best way, but it works.

Wabos

Please Login or Register  to view this content.