transfering data between sheets

  • Thread starter Thread starter Parker Jones
  • Start date Start date
P

Parker Jones

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

IF the value in H=1 THEN transfer said row to sheet 2
IF the value in H=2 THEN transfer said row to sheet 3
etc.

I need all the information in the row to transfer, and have no idea how to
do it.
 
More info needed but a macro like

with sheets("sheet2")
lr=.cells(rows.count,1).end(xlup).row+1
rows(range("h1")).copy .cells(lr,1)
end with
 
I need a formula that says something to the effect of:

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

I need 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,
 
Sub copytovariablesheet()
With Sheets("sheet" & Range("a1"))
lr = .Cells(Rows.Count, 1).End(xlUp).Row + 1
'MsgBox lr
Range("a1:a10").Copy .Cells(lr, 1)
End With
End Sub
 
Thanks Don, I was just wondering where to put that formula.

My master list is on Sheet 2 and I need the value in column H (3-12) to
transfer its row (ex: A5-J5) to the sheet corresponding to H (3-12).

So if H5 reads 7 then A5:J5 have to move to the next available row on sheet
seven.

Thank you for all of your help so far.
 
I sent an attachment to your email. Thank you for all of you help. It is
kinder than you know.
 
Back
Top