I'm attempting to copy all rows from sheet "meowmix" that meet certain requirements paste those rows to sheet "woofmix".
Ideally, I would like overwrite all row on "woofmix" ,except for the first row, with the copied rows from "meowmix".
The below code successfully identifies rows with requirements and pastes them to the target sheet, however, it adds on to the target sheet rather than replacing. I'm not having an issue with suppressing the 'overwrite destination cells' dialogue box. I'm having and issue overwriting.
Bookmarks