Sorry for this question but its late in the day and I need the answer
tomorrow. I have a "master" spreadsheet with records in rows with
unique numbers in the "ABN" column (in column "E"). I have a subset of
"ABN"s which are valid. I want to use this subset somehow to copy valid
rows of records from the "master" spreadsheet to another spreadsheet I
have created. I think you can do this with vLookup, I think I have done
this before with vLookup, but I can no longer understand my own notes
on how to do this. I want to do this manually, not using VBA. Thanking
you now for any assistance and I will definitely get back to everyone
with my feedback.