Hi, is there anyway to paste values filtered data other than unfiltering data and going through the cells one by one as i dont want to paste values all cells. At the moment i am getting an error when the data is filtered and i select the cells i want to paste values.