Is it possible to select a row based on a criteria of it containing data.
for example, my filter identifies a row i want to copy and paste to another sheet
my loop stops in column F on row 50 and i want to copy and paste data from columns A:P on row 50 to another sheet. Selecting the row using Entirerow isnt optimal. Could anyone kindly propose a better solution?
Many thanks,
D
Bookmarks