I need to create a formula that when an "x" is put in chosen cell, certain
information is copied and pasted into new worksheet Report. So far I have
created;
=if(a1:a100="x", This works to activate formula, but
how do I copy and paste particular data inside this formula?
Phil