how do I copy and paste data with a formula?

[Guest]

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

 

[Anne Troy]

What are you doing if X is in the cell? You don't use a formula to "paste".
But you could use Find and replace (Ctrl+H) to replace "x" with something
else. Or, if that "particular data" is in column C, perhaps your formula
should read (and be copied down):
=if(a1="x",c1,"WhatYouWantIfItDoesn'tEqualX")
************
Anne Troy
www.OfficeArticles.com

 

[Don Guillett]

More info??

 

[Guest]

Anne,
Lets say I have "info" in cells A1:E1 in worksheet 1 (New or different info
expanding downward)
column F1 is my "x" column. When I put an "x" in any cell in Column F I want
to transfer the data from CORRESPONDING 1-5 cells in that same numbered row
from Worksheet 1 to likewise cells on Worksheet 2 is this possible? or am I
not approaching the formula correctly?

Phil

 

[Anne Troy]

"Duplicating" data like this isn't the way I'd go about it, but you could
use IF statements. The problem is, how many cells on sheet1 will you be
returning to sheet 2? You'll have to do something like
=if(sheet1!f2="x",sheet1!a2,"")
Changing the formula for each row/column.
What are you wanting to see? Why not instead put the X's in and do an
autofilter?
************
Anne Troy
www.OfficeArticles.com