I've tired to work with this MACRO but I am trying to combine the content in order for it to work yet I keep getting bugs.
The purpose of this is to pick certain information from sheet 1 and transfer it to sheet 2 in the last rows available.
Dim faRow, x As Integer
x = ActiveCell.Row
faRow = Sheets("Total").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row