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

Hi Ronald

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

--
Regards

Roger Govier


"Ronald" wrote in message
...
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

Hi Roger,

This was really a good tip.

Thanks,

Ronald

"Roger Govier" wrote:

Hi Ronald

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

--
Regards

Roger Govier


"Ronald" wrote in message
...
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