Making a compiled list in Excel

[TheRobsterUK]

Hi all,

I'm trying to create an Excel spreadsheet that can create a compile
list from an existing list. By this I mean there is a list of item
which represents the complete list and each entry has a checkbox nex
to it to indicate whether it has been selected or not, and then on th
same worksheet there is another list which only contains the items tha
have been selected from the first, full list.

Check out these screensheets to get a better idea of what I mean:

http://homepages.nildram.co.uk/~proebuck/excel1/JPG

http://homepages.nildram.co.uk/~proebuck/excel2.JPG

I think this should be possible using some kind of databas
range/filter/criteria type functions. I've tried using a pivot tabl
but the problems are that this doesn't update everytime yo
select/deselect another item (it has to do this) and it seems to be a
over-complicated solution for what is essentially a simple task......o
it seems simple but I can't get it to work!

Also, the items in the compiled list have to appear in the same orde
as the original list. I'm also not sure if just hiding a row would wor
as Excel still counts the cells as being there e.g. if you copy/past
the cell range then any hidden cells are also copied and I don't wan
this to happen.

Any ideas?

Cheers
-Ro

 

[Frank Kabel]

Hi
'Data - Filter - Advanced Filter' or try Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

 

[Don Guillett]

You may have over complicated this. Why not just put a x beside each and use
data>filter>autofilter>filter on the non blanks>use =SUBTOTAL to
count/sum/avg and use f5 copy visible cells only. Why do you need the
checkbox.