what formula?

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top