Excel IF Formulas

[mgreen-NJ]

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.

 

[JLatham]

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]

Thank you for the response.

Yes by "move" I literally mean move the entire row to the new sheet and
delete it off the master sheet.

Eventually what should happen is something on sheet 1 will end up on sheet 9
as it moves through the different phases of processing. So "A1" will start
as a "1" and at some point change to a "2" and so on and so on until it
eventually becomes "9" . The entire row will be complete and ready to move
as soon as it is input into the master sheet. The only item that should
change would be "A1" as it moves along and maybe another cell that will have
"comments" written in it.

Technically I probably don't even need a master sheet - since everything
will start out as a "1" and then move through. It's just that I already have
a master sheet now where all the information is contained that we continue to
add to on a daily basis and didn't want to start over if it could be avoided.

Thanks again.