Auto selection of rows by matching a list of serial numbers

[zicitron]

Hi all,

I have an Excel worksheet with one of the columns named "Serial Number". I need to select specific rows and copy those selected rows in a new worksheet, based on a list of serial numbers (which is not necessarily consecutive numbers).

Can anyone help with a VBA (or may be a formula?) to automatically select the rows based on a list of serial numbers? I can do a manual copy and paste once the rows have been selected. That would be half the job done!

I am using Excel 2013.

 

[vds1]

Keep the list of serial numbers in another sheet, say sheet2. Then apply vlookup on main sheet where you have whole list of serial numbers,say sheet1 (assuming serial number is in column A)

So In sheet1 Column B, use this formula

=VLOOKUP(A2,Sheet2!A:A,1,0)

Next, Filter column B , uncheck #N/A

 

[DILIPandey]

Hi Zicitron,

Are you filtering and copying ?
Can you provide more details on the criteria ? thanks.


Regards,
DILIPandey

 

[zicitron]

Thanks vds1! Not a bad solution!
DILIPandey, it may be seen as a filtering to select only the rows with the serial numbers I need.

 

[DILIPandey]

Okay.. would be easy if you can paste your data sample so that I can provide a small macro to do this. I like to know which column you would be filtering and what is the range etc. Thanks.


Regards,
DILIPandey