Hi all,

I'm trying to create an Excel spreadsheet that can create a compiled list from an existing list. By this I mean there is a list of items which represents the complete list and each entry has a checkbox next to it to indicate whether it has been selected or not, and then on the same worksheet there is another list which only contains the items that 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 database range/filter/criteria type functions. I've tried using a pivot table but the problems are that this doesn't update everytime you select/deselect another item (it has to do this) and it seems to be an over-complicated solution for what is essentially a simple task......or it seems simple but I can't get it to work! Do I need a VBA routine to make this work or what?

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

Any ideas?

Cheers
-Rob