Make values appear automatically in other sheet...

[rmcmaillet98]

Dear All,

I have a Database (hereby called "Table") in which one are managed documents and actions to complete bounded to those documents. In this Database, appear the columns " USER | NAME | ACTION | idDoc | Title | Description ".

I would like to make appear automatically in other sheet (called "Action List") all actions to do and the values of the following columns " USER | NAME | ACTION | idDoc ".

Thanks a lot in advance,

Raphael

PS : document link http://www.cjoint.com/c/GHwiOV7UKLQ

[Glenn Kennedy]

?? Is this what you mean?

In Action List, A2, copied across and down:

=IF(Table!A2="","",Table!A2)

You will need ; instead of , if you are using French settings.