Remove duplicates with variable range

Hi Guys
I am copying rows from one sheet to another then I want to check if the second sheet has any duplicates. I have checked on line but all the examples have predefined ranges. Here the rows will change every time and the columns may change.
I am enclosing a sheet just in case, though it may not be necessary. I am copying from BDC2 to Transactions and then removing duplicates from Transactions .

I want to be able to check for duplicates with the rows and columns to the last cell as in Ctrl End (but when I use that it gives the last cell as fixed in the code).
Hope this makes sense.
Looking forward to finding a solution. Thanks in advance.

Mark