Copy and Paste based on Condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a condition is true in a colum or series, I would like to grab a value in
another column and place it in a given cell in another tab.

Can anyone help with this?
 
A formula can only be used to return a value to the cell in which it
is placed - it cannot "push" a value to another cell. So, you will
need a formula in the cell where you want this value to appear, along
the lines of:

=IF(the_condition_is_true,Sheet1!A1,"")

which assumes you want to get the value from A1 in Sheet1 - adjust as
necessary.

Hope this helps.

Pete
 
Back
Top