what formula?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

quite a day for my excel skills.... here is one I can't figure out.
If a condition is met in a cell, how can I get that whole row to transfer
over to a new sheet?
In other words the data in a row is automatically transfered to the next
sheet if a certain entry is made into a cell in that row.
is there an "IF" formula for that?, or are we getting into scary VB
territory!
D
 
Hi Dave!

A formula or function can only return a value to the cell it is in. A
formula can’t change the Excel environment.

See:
170787 XL: Custom Functions Can't Change Microsoft Excel Environment

http://support.microsoft.com/default.aspx?scid=kb;en-us;170787

To do what you want will require VBA.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top