I have a sheet where I use conditional formatting to highlight a row. I want to be able to transfer the specific columns of the highlight cells to another sheet into different columns. For example, I want to move all of the highlighted cells in column 3 to move to the other sheet in column 4. Any advice or tips on where to start since I am fairly new to VBA?