how to know or check the last row in the worksheet using vba

[excelkeechak]

hi,

I had a sheet with many columns. i want to select the cells starting from row one to the last row in the worksheet, then copy it and paste it in other sheet.

1. How do i know which cell is the last one in the sheet
2. how to select the rows or cells when i use the auto filter in the worksheet and select certain Cells like PCs in my example.
i need to select all of them,copy the whole row containing that particular word and paste it in other sheet.

My data keeps changing every day in the above scenario. I tried using the UsedRange Property

How do i solve this.