Otto - By Automatically i would like the trigger to be as an entry is made.
Sorry i didn't clarify this before, and my apologies for not spotting your
reply.

Best regards


"Otto Moehrbach" wrote:

The question now is; What do you mean by "automatically? Specifically, what
do you want to use as the trigger that induces Excel to do this for you?
For instance, Excel can do this each and every time that an entry is made in
that column that the users use for input. Or Excel can do this whenever the
file is saved. Or closed.. Or opened. HTH Otto
"Zebediah" wrote in message
...
is there anyway the summary list can be populated automatically? i have a
lot of these forms. Also the users need the summary list themselves,
without
intervention from me...if possible.

Many thanks for the quick response though.



"Don Guillett" wrote:

use datafilterautofiltercopy the filtered

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zebediah" wrote in message
...
On one sheet I have a long list of items which I need my users to
scroll
down
and, when needed, fill in a value next to the appropriate item in the
list.

Most of the list items will not need anything inputting against them.

Then on a different sheet I need a nice tidy summary list which only
shows
those list items which have an input against them.

The bit I can't do is getting these few items to display (on a separate
sheet) in a nice neat all together, contiguous way - ie with no gaps

any ideas?