transfering data between sheets

[Parker Jones]

I need a formula that says something to the effect of:

IF the value in A1=2 THEN transfer A1:A10 to next available row in sheet 2
IF the value in A1=3 THEN transfer A1:A10 to next available row in sheet 3
etc.

I need all the information in the row to transfer to the next available row,
and have no idea how to do it.

IF(A1=2,(?????),IF(A1=3,(?????),"bad"))

????? needs to transfer A1:A10 to next available row in another sheet

If you can help,

 

[jamescox]

The key thing to remembe about Excel cell formulas is that while they
can *depend* on other cell values (ie, reference the cells directly or
indirectly) they can only change the value of the cell they are in.

In other words, you can't have a cell formula that does anything *to*
another cell. Therefore, to get where you want to go, you will have to
write VBA code and decide what will run that code.

You might take another look and see if you can set up formulas on sheet
2 and 3 that 'pull' values from sheet 1 into where you want them on
sheets 2 and 3, but Excel cell formulas can't 'push' values into another
cell.

Good luck!