This is probably going to end up being a VBA/Macro solution that would be
executed at the click of a button on the sheet. Best not to try to do it
automatically because you probably don't know whether or not when A1 = 1 that
the rest of the row is ready to be moved.

But by "Move" do you mean that literally, as copy that row of information to
some other sheet and then delete the row from the master sheet, or
Do you mean just copy it to the other sheet and leave the original
information in place on the master sheet? If this is the case, then we'll
also need a way of marking a row as having already been copied to some other
sheet.


"mgreen-NJ" wrote:

Good afternoon -

I need to create a formula in a cell that indicates if that particular cell
returns a certain value then the entire row of information should be moved to
a different sheet.

For lack of a more formal formula I'm trying to get something that works
along the following concept:

"IF cell A1=1 then move Row 1 to sheet 2 or if cell A1=2 then move Row 1 to
sheet 3", etc., etc.

I basically have a pipeline of information on a master sheet that I would
like to split up into 9 different sheets (all in 1 file) depending on what
the status is of a particular item. As I change the status of the item I
want it to automatically move the row of information to the appropriate sheet.

I'm used to working with the basic math functions and I don't usually work
with IF scenarios. Is this something that can be done?

Thank you.