How can I paste rows from worksheet A to B using values common to both worksheets?

  • Thread starter Thread starter Cloudfall
  • Start date Start date
C

Cloudfall

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.
 
I'm assuming that the subset of valid numbers in a single column on a separate
worksheet (sheet2, column A).

You could insert a new column in you original master data.
Use a formula like:

=isnumber(match(a2,sheet2!a:a,0))
and drag down

Then filter by that column.

The True's are matches (valid). The False's don't match.

So filter to show the True and then copy those visible rows to your new
worksheet.

(Or just leave it in place and keep one copy of the data???)
 
Thank you yet again for your help. It has worked just as you said. I'm
only now starting to get into worksheet functions and hope to get the
hang of them, and then possibly find out the range of what they do. All
the best to you and yours.
 
Glad it worked for you.
Thank you yet again for your help. It has worked just as you said. I'm
only now starting to get into worksheet functions and hope to get the
hang of them, and then possibly find out the range of what they do. All
the best to you and yours.
Click to expand...
 
Back
Top