automaticly paste info from another sheet

[Guest]

2003 Excell - I'm asking a customer what they need, expected responses are in
column "B". Column A is a small box to be "X" 'd alongside the need they
express (column "B"). I want my "features and benefits" from another sheet to
automaticly paste to this sheet when I've placed an "X" in the box
corresponding to the need the customer has expressed.

Basicly: make info automaticly paste from another sheet by having something
entered into a cell.

 

[squenson via OfficeKB.com]

You have two ways to make "automatic" paste:
1) A formula
You could have in column C something like (adapt the row #'s), for example C4:
= IF(A4="X",mySheet!D4,"")
This will only display information when column A contains X

2) A macro
More complex, and it requires more info about the info to paste.

Stephane Quenson.