Create new inventorylist from stocklist

[Guest]

I have a worksheet with all kind of furniture. Now i want to move the
selected furniture to a new worksheet creating a new list.

eg.

Serialnumber number of art. Description Location
100001 2 chair A
200006 4 table B
500009 12 Coat hangers C

What i am looking for is that when i set the number of items to be moved in
column 5 that it automatically copies the serial number and description to a
new worksheet, creating a new inventorylist. It would be very nice if there
are no empty lines in the new list, meaning that the selected items should
follow up each other.

Many thanks to those who can help me.

Ronald

 

[Roger Govier]

Hi Ronald

Take a look at the technique using Advanced Filter on Debra Dalgleish's
site
http://www.contextures.com/xladvfilter01.html#ExtractWs

 

[Guest]

Hi Roger,

This was really a good tip.

Thanks,

Ronald